Tag: PostgreSQL

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces:PT-1741: Migration to a new MongoDB driver was done.PT-1344: pt-online-schema-change failed to detect hostnames with a specified port numberPT-1630: pt-table-checksum had a regression which prevented it from working with Galera clusterPT-1709: pt-upgrade generated “Use of uninitialized value in concatenation (.) or string” error in case of invalid MySQL packetsPT-1728: pt-table-checksum failed to scan small tables that ... Read More

Feed: Planet MySQL; Author: Alena Subotina; .NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.This year, a new .NET Core 3 is coming. It is currently available as .NET Core 3.0 Preview 9, and despite its preview status, Microsoft officially recommends it to full production use. Besides, Microsoft sends some signals that the development of Full ... Read More

Feed: Planet PostgreSQL. Postgres is the leading feature-full independent open-source relational database, steadily increasing its popularity for the past 5 years. TimescaleDB is a clever extension to Postgres which implements time-series related features, including under the hood automatic partioning, and more.Because he knows how I like investigate Postgres (among other things) performance, Simon Riggs (2ndQuadrant) prompted me to look at the performance of loading a lot of data into Postgres and TimescaleDB, so as to understand somehow the degraded performance reported in their TimescaleDB vs Postgres comparison. Simon provided support, including provisioning 2 AWS VMs for a few days each.SummaryThe ... Read More

Feed: Planet PostgreSQL. We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it:CREATE TABLE t (id integer PRIMARY KEY); CREATE VIEW v AS SELECT * FROM t; DROP TABLE t; ERROR: cannot drop table t because other objects depend on it DETAIL: view v depends on table t HINT: Use DROP ... CASCADE to drop the dependent objects too. ALTER TABLE t DROP id; ERROR: cannot drop column id of table t because other objects depend on it DETAIL: view v depends on column id of table t HINT: Use DROP ... Read More

Feed: Planet MySQL; Author: VividCortex; When you're trying to understand your systems and why they behave as they do, one of the most powerful questions is "what changed?" or "what's different?" We've offered this capability for years in VividCortex, and now we've added it to the more recent Explorer feature so you can interrogate your databases and discover what's new and different about them ... Read More

Feed: R-bloggers. Author: modern.data. [This article was first published on R – Modern Data, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Tools capable of producing rich analytic reports and data visualizations are a valuable resource for decision makers in any field. Dash is an open-sourced based framework for building dynamic web applications that seamlessly integrates interactive graphics and tabular data summaries, serving as a catalyst for data-driven decision-making. Several features of Dash ... Read More

Feed: Planet PostgreSQL. Where are you? Go ahead and figure out your answer, I'll wait.No matter what your answer, whether you said "sitting in my office chair" or "500 meters south-west of city hall" or "48.43° north by 123.36° west", you expressed your location relative to something else, whether that thing was your office layout, your city, or Greenwich. A geospatial database like PostGIS has to have able to convert between these different reference frames, known as "coordinate reference systems". The math for these conversions and the definition of the standards needed to align them all is called "geodesy", a ... Read More

Feed: Planet MySQL; Author: Severalnines; Microsoft Azure is known to many as an alternative public cloud platform to Amazon AWS. It's not easy to directly compare these two giant companies. Microsoft's cloud business -- dubbed commercial cloud -- includes everything from Azure to Office 365 enterprise subscriptions to Dynamics 365 to LinkedIn services. After LinkedIn was acquired by Microsoft it began moving its infrastructure to Azure. While moving LinkedIn to Azure could take some time, it demonstrates Microsoft Azure’s capabilities and ability to handle millions of transactions. Microsoft's strong enterprise heritage, software stack, and data center tools offer both familiarity ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a theme author, potentially more exciting are the updates to our theme JSON format which make it much quicker and easier for you to create your own custom themes that significantly change the look and feel of your ... Read More

Feed: Planet PostgreSQL. Posted by Devrim Gündüz on Monday, September 9. 2019 PostgreSQL 12 is in beta right now, and we need everyone to test it!We have been building repos even from daily builds, Below are the steps to install PostgreSQL 12 on RHEL 8: First, please ownload repo rpm from here: https://yum.postgresql.org/repopackages.php. You can copy and paste the following lines on your box:On RHEL 8: yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmOn RHEL/CentOS 7: https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpmOn Fedora 29+: yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/F-30-x86_64/pgdg-fedora-repo-latest.noarch.rpmOn RHEL/CentOS 7 and 8, you need to enable EPEL repo, if you want GIS packages as well:RHEL : yum -y install ... Read More