Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 9, 2020
Multi-Master Replication Solutions for PostgreSQL
Due to the immense generation of data, scalability has become one of the hottest topics in the field of databases. [...]
May 29, 2020
Removing PostgreSQL Bottlenecks Caused by High Traffic
Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the [...]
May 21, 2020
Failover of Logical Replication Slots in PostgreSQL
Missing Piece: Failover of the Logical Replication Slot Logical decoding capability has existed in PostgreSQL for the last several versions, [...]
May 19, 2020
Introducing an Update to Percona Distribution for PostgreSQL
Percona is pleased to announce the release of an updated version of Percona Distribution for PostgreSQL. Following on our initial [...]
April 13, 2020
Webinar 4/22: The Evolution of PostgreSQL Partitioning
PostgreSQL Partitioning has evolved in different versions of PostgreSQL and now has solid scalability features. PostgreSQL has three different kinds [...]
March 30, 2020
Webinar 4/8: Why PostgreSQL is Becoming a Migration Target in Large Enterprises
The adoption and market share of PostgreSQL is growing at a rapid rate. And it’s not just new installations or [...]
March 25, 2020
A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it [...]
March 12, 2020
Adding PostgreSQL Databases/Tables Size Dashboard to the Percona Monitoring and Management Plugin
This blog post is about how you can gain detailed information in Percona Monitoring and Management (PMM2) of PostgreSQL disk [...]
February 13, 2020
Compression of PostgreSQL WAL Archives Becoming More Important
As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new [...]
February 7, 2020
Webinar 2/19: 17 Things Developers Need to Know About Databases
Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, [...]
January 21, 2020
Ever Heard of Postgres?
Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of [...]
January 17, 2020
Upgrading PostgreSQL – Patroni Cluster and Switching from Python 2 to Python 3
Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be [...]
December 3, 2019
PostgreSQL 12 Improvement: Benign Log Entries “Incomplete Startup Packet”
There is a less-talked-about improvement in PostgreSQL 12 which can greatly reduce the benign log entries. This patch is probably [...]
November 20, 2019
Proposal for Global Indexes in PostgreSQL
A global index, by very definition, is a single index on the parent table that maps to many underlying table [...]
November 8, 2019
Configure HAProxy with PostgreSQL Using Built-in pgsql-check
We discussed one of the traditional ways to configure HAProxy with PostgreSQL in our previous blog about HAProxy using Xinetd. [...]
October 31, 2019
PostgreSQL Application Connection Failover Using HAProxy with xinetd
Recently we published a blog about a very simple application failover using libpq features which could be the simplest of [...]
October 29, 2019
Monitoring PostgreSQL Databases Using PMM
PostgreSQL is a widely-used Open Source database and has been the DBMS of the year for the past 2 years [...]
October 23, 2019
Seamless Application Failover using libpq Features in PostgreSQL
When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This [...]
October 11, 2019
How to Set Up Streaming Replication in PostgreSQL 12
PostgreSQL 12 can be considered revolutionary considering the performance boost we observe with partitioning enhancements, planner improvements, several SQL features, [...]