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.

We tend to rely on caching solutions to improve database performance. Caching frequently-accessed queries in memory or via a database can optimize write/read performance and reduce network latency, especially for heavy-workload applications, such as gaming…

One of the main tasks of any kind of administrator is to make sure that the data that he's responsible for will be available if anything ...

PostgreSQL Replication is when data is copied from one database server to another. The source database server is usually called the Master server, whereas the database server receiving the copied data is called the Replica server.

Sentinel's PostgreSQL database can take up a large amount of disk space, especially if you are utilising the Sentinel Identity Tracking solution. This is a result of the way PostreSQL functions. When a row in a table is deleted or updated, it is only marked…