Architecture overview of the PostgreSQL capabilities and its interaction with the client and the operating system. The server could be divided roughly into four subsystems.

A single query optimization tip can boost your database performance by 100x. At one point, we advised one of our customers that had a 10TB database to use a date-based multi-column index. As a result, their date range query sped up by 112x. In this post,…

26.4. Hot Standby # 26.4.1. User's Overview 26.4.2. Handling Query Conflicts 26.4.3. Administrator's Overview 26.4.4. Hot Standby Parameter Reference 26.4.5. Caveats …

Hans-Jürgen Schönig

PostgresConf South Africa 2019

https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/postgresql-performance-in-5-minutes

Are you suffering from bad performance? Is your database slow and does not satisfy your needs?…

DBAs and developers use pganalyze to identify the root cause of performance issues, optimize queries and to get alerts about critical issues. Sign up for free!

One of the most challenging thing when scaling your backend to a new server cluster in a new region is replicating the databases. Most of…

Bi-Directional Replication (BDR) from 2ndQuadrant is an Advanced Clustering & Scaling tool for PostgreSQL databases. It presents true high availability for mission critical databases running on PostgreSQL, and is used across various industry verticals such…

19.6. Replication # 19.6.1. Sending Servers 19.6.2. Primary Server 19.6.3. Standby Servers 19.6.4. Subscribers These settings control the behavior of the …

TL;DR: JSONB has potential for greatly simplifying schema design without sacrificing query performance.
Introduction It must be one of the oldest use cases in the world of relational databases: you have an entity, and you need to store certain properties…

This article looks at parameters that can be used to help manage memory in PostgreSQL. Recommended settings for each parameter are also provided.