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
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 15 Aug 2019
A Faster, Lightweight Trigger Function in C for PostgreSQL
We have been writing blog posts about how to write simple extensions in C language and a little more complex one by Ibrar which were well received by PostgreSQL user community. Then we observed that many PostgreSQL users create simple triggers for small auditing requirements, and then feel the pain of trigger on transactions. […]
Read more 31 Jul 2019
PostgreSQL: Simple C extension Development for a Novice User (and Performance Advantages)
One of the great features of PostgreSQL is its extendability. My colleague and senior PostgreSQL developer Ibar has blogged about developing an extension with much broader capabilities including callback functionality. But in this blog post, I am trying to address a complete novice user who has never tried but wants to develop a simple […]
Read more