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 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 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 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... 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 been... by Robert Bernier | Sep 29, 2020 | Insight for DBAs, Open Source, PostgreSQL
So you’ve installed postgres onto your machine, and you want to start working with it. How? The key to understanding the post-installation procedure is to realize that it “depends”.It “depends” on the OS i.e. MSWindows vs Linux. It... by Robert Bernier | Jun 25, 2020 | Database Trends, Insight for DBAs, Security
Today I’m going to talk about my favorite trope, “database security”.When done right, a good security policy not only protects your data but improves performance, system stability, and enhances the development life-cycle. When done wrong it not only... by Robert Bernier | Jun 4, 2020 | Monitoring, PostgreSQL, Security
Security, when done right, not only protects your data but improves performance, system stability, and enhances the development life-cycle. Because PostgreSQL security can easily become an all-encompassing activity, we’ll deal with the most common... by Robert Bernier | May 29, 2020 | Insight for DBAs, PostgreSQL
Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic. Many stacks these days are implemented by trusting the Object... by Robert Bernier | Jan 21, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of 2019 but things have been so busy that this is the first chance I’ve had to write.For my first blog, I’d like to write about … you. Or,...