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.
Read more 03 Dec 2019
20 Nov 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 partitions. The parent table itself does not have a single, unified underlying store so it must, therefore, retrieve the data satisfying index constraints from physically distributed tables. In very crude terms, the global index […]
Read more 08 Nov 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. There we briefly mentioned the limitation of the HAProxy’s built-in
Read more 31 Oct 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 all automatic application connection routing. In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment. There […]
Read more 29 Oct 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 in
Read more