by Jobin Augustine | Aug 10, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Many times, we see PostgreSQL users getting confused about the query/statement duration reported in PostgreSQL logs. Other PostgreSQL tools like pgBadger present the same data based on the log file, which further increases the confusion. Knowing the full impact of...
by Ibrar Ahmed | Jul 30, 2021 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well. PostgreSQL provides very...
by Charly Batista | Jul 29, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
by David Gonzalez | Jul 26, 2021 | Cloud, Insight for DBAs, PostgreSQL
We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific...
by Robert Bernier | Jul 19, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the table schema too. Operations such as adding, editing, and removing table columns are part of today’s life-cycle reality...
by Robert Bernier | Jun 28, 2021 | Insight for DBAs, Open Source, PostgreSQL, Security
PgBouncer is a great piece of technology! Over the years I’ve put it to good use in any number of situations requiring a particular type of control over application processes connecting to a postgres data cluster. However, sometimes it’s been a bit of a...
by Jobin Augustine | Jun 24, 2021 | Insight for DBAs, PostgreSQL
pg_repack is one of the oldest, widely used, extension projects for PostgreSQL. It is so much popular that even DBaaS service providers couldn’t avoid it. It is a “power tool” in the hands of a DBA to deal with bloated/fragmented tables. I...
by Dmitriy Kostiuk | Jun 23, 2021 | Cloud, MongoDB, MySQL, Percona Software, PostgreSQL
At some point, your needs for improving database performance may run into a threshold where optimization and tuning are no longer enough. If you cannot change the database engine and can no longer tune the parameters for your workload, you need to use scaling. As it...
by Fernando Laudares Camargos | Jun 11, 2021 | Insight for DBAs, Percona Live, Percona Software, PostgreSQL
A couple of weeks ago, Jobin and I did a short presentation during Percona Live Online bearing a similar title as the one for this post: “PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them”. We deployed a 3-node PostgreSQL...
by Ibrar Ahmed | Jun 2, 2021 | Insight for DBAs, PostgreSQL
Note: PostgreSQL 14 has been released. Please visit PostgreSQL 14 – Performance, Security, Usability, and Observability for additional information. It’s exciting times in the PostgreSQL world with the version 14 beta released a few days ago. It’s now time to...
by Ibrar Ahmed | May 27, 2021 | Insight for DBAs, PostgreSQL
On September 30, 2021, PostgreSQL 14 was released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. Foreign Data Wrapper based on SQL-MED is one the coolest features of PostgreSQL....
by Sergey Pronin | May 26, 2021 | Cloud, Open Source, Percona Software, PostgreSQL
Percona is championing open source database software and we are committed to running our products on Kubernetes. We don’t only want to run the software, but make sure that the database is highly available, secure, and follows best practices. We also focus on day-2...
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....
