Tag - PostgreSQL

PostgreSQL Security Missteps and Tips

postgresql security tips

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 mechanisms.
Three files control security in the postgres data cluster but for our purposes, we’ll deal only with postgresql.conf and pg_hba.conf, […]

Read more

Removing PostgreSQL Bottlenecks Caused by High Traffic

PostgreSQL Bottlenecks High Traffic

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 Relational Mapper, ORM, to do the right thing with PostgreSQL while one creates critical business logic on […]

Read more

Failover of Logical Replication Slots in PostgreSQL

failover logical replication slots postgresql

Missing Piece: Failover of the Logical Replication Slot
Logical decoding capability has existed in PostgreSQL for the last several versions, and a lot more functionalities are added over time.  However, one of the very crucial functionalities is still missing in PostgreSQL, which prevents logical replication to be part of critical production environments where downstream expects […]

Read more

Introducing an Update to Percona Distribution for PostgreSQL

Percona Distribution for PostgreSQL

Percona is pleased to announce the release of an updated version of Percona Distribution for PostgreSQL. Following on our initial PostgreSQL Distribution, released in September 2019, this update incorporates the new features of PostgreSQL 12.2 Core Distribution including:

Less custom design work is required with SQL and DDL improvements that provide more flexibility and easier […]

Read more