by Robert Bernier | Apr 22, 2021 | Insight for DBAs, Open Source, PostgreSQL
These scripts demonstrate the command line interface, CLI, “pg_rewind” re-provisioning a formerly deprecated PRIMARY host, pg1, into a viable STANDBY. Although the scripts have been written expressly for a custom-made set of two Linux containers using...
by David Quilty | Mar 9, 2021 | Insight for DBAs, PostgreSQL, Webinars
Join Peter Zaitsev, Percona CEO, and Ibrar Ahmed, Percona Sr. Software Engineer, as they discuss pg_stat_monitor! If you’re tasked with optimizing PostgreSQL performance, chances are you’re relying on the pg_stat_statements extension to capture information...
by Robert Bernier | Mar 8, 2021 | Benchmarks, Hardware and Storage, PostgreSQL
Some time ago we at Percona were approached by ScaleFlux Inc to benchmark their latest hardware appliance, the CSD 2000 Drive, which is a next-generation SSD computational storage drive. It goes without saying that a truly relevant report requires us to be as honest...
by Jobin Augustine | Feb 26, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of...
by Ibrar Ahmed | Feb 1, 2021 | Insight for DBAs, PostgreSQL, Security
Recently, I wrote an overview about what you need to know about PostgreSQL security. For this post, I want to write about PostgreSQL authentication. It is divided into three categories: 1. PostgreSQL Internal Authentication, 2. OS-based Authentication, and 3. External...
by Ibrar Ahmed | Jan 28, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Some time ago, I required a specific version of PostgreSQL. After searching on all the repositories, I was unable to find that specific version. It seems that the PostgreSQL community removes the old package when a new minor version comes. For example, if you need the...
by Nickolay Ihalainen | Jan 27, 2021 | Benchmarks, MariaDB, MongoDB, MySQL, PostgreSQL
I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By… Docker (or Podman)...
by Jobin Augustine | Jan 22, 2021 | Benchmarks, Cloud, Insight for DBAs, PostgreSQL
The expected growth of ARM processors in data centers has been a hot topic for discussion for quite some time, and we were curious to see how it performs with PostgreSQL. The general availability of ARM-based servers for testing and evaluation was a major obstacle....
by Robert Bernier | Jan 19, 2021 | Insight for DBAs, Percona Software, PostgreSQL
Enter pg_stat_monitor: this extension, created here at Percona, has been developed as an advanced replacement of pg_stat_statement, providing new capabilities in addition to the standard fare. As you may recall, PostgreSQL’s pg_stat_statements extension provides a...
by David Quilty | Jan 14, 2021 | PostgreSQL, Webinars
PostgreSQL is one of the leading open-source databases, but, out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum performance on high permanence...
by Robert Bernier | Jan 11, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements. Of the many new features and enhancements that have...
by Matt Yonkovit | Jan 7, 2021 | Database Trends, Open Source, PostgreSQL
For the third time in the last five years, PostgreSQL took home the Database of the Year award from DB-Engines. If you have not checked out DB-Engines before, they track databases’ popularity by looking at job openings, blog posts, search traffic, and more....
by Jobin Augustine | Dec 1, 2020 | Insight for DBAs, Percona Software, PostgreSQL
In one of my previous blog posts, Why PostgreSQL WAL Archival is Slow, I tried to explain three of the major design limitations of PostgreSQL’s WAL archiver which is not so great for a database with high WAL generation. In this post, I want to discuss how...
by Daniil Bazhenov | Nov 9, 2020 | Insight for DBAs, MySQL, Open Source, PostgreSQL
Percona University Online has released its second free course, “A Deep Dive Into PostgreSQL Indexes” by Ibrar Ahmed, Senior Software Engineer at Percona. Indexes are a basic feature of relational databases. PostgreSQL offers a rich collection of index...
by Ivan Groenewold | Nov 5, 2020 | MongoDB, Monitoring, MySQL, Percona Software, PostgreSQL
Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public...
by Rick Golba | Oct 19, 2020 | Open Source, Percona Software, PostgreSQL
Percona is pleased to announce the release of Percona Distribution for PostgreSQL 13. This release is available for immediate download and includes all of the latest features of PostgreSQL 13 Core Distribution. Reduce Resource Usage This release includes enhancements...
by Peter Zaitsev | Oct 14, 2020 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database. Why? Because if you look from an application developer’s point of view, once a database is provisioned and you...
by Daniil Bazhenov | Oct 12, 2020 | MongoDB, MySQL, Percona Services, Percona Software, PostgreSQL
Have you recently visited Percona’s Community Forum? It’s your hub for direct Q&A with top database experts, including Percona CEO Peter Zaitsev and CTO Vadim Tkachenko. Last quarter over 450 users participated, including 45 engineers from Percona’s staff. Since...
by Daniil Bazhenov | Oct 5, 2020 | Open Source, Percona Announcements, Percona Software
Would you like to get the latest in Percona gear 100% free, shipped to you anywhere in the world? Maybe that sounds too good to be true, but it’s true! It’s easy and takes as little as 20 minutes to earn your swag. Here are some examples of the swag items you can...
by Ibrar Ahmed | Oct 1, 2020 | Insight for DBAs, Open Source, PostgreSQL
There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb...
