About regression tests with Postgres plug-in modules

2013-12-09 04:01:32 +0000

PostgreSQL is made to be pluggable. With many types of plug-in structures available directly in core that make the development of external tools or even modules that can be directly be uploaded in a server with an untouched core code, there are many ways for a developer to develop a solution with things like hooks, foreign data wrappers, background workers, custom data types, (index) operators, functions, aggregates that can be loaded through extensions or defined as they are.

Postgres 9.4: Be aware of behavior modification for SET and ABORT/ROLLBACK

2013-11-29 03:24:29 +0000

Here is something to be aware of if you have a couple of scripts relying on this behavior: ROLLBACK, ABORT and SET behavior have been changed in PostgreSQL 9.4. The modification has been introduced by this commit:

Postgres 9.4 feature highlight - TABLE for multiple functions and multi-argument unnest()

2013-11-25 04:02:12 +0000

A new feature making possible to specify multiple functions with TABLE inside a FROM clause has made its way in Postgres. The same commit adds support for unnest with multiple arguments as well.

Postgres 9.3 feature highlight - COPY TO/FROM PROGRAM

2013-11-18 04:27:43 +0000

Postgres 9.3 brings a new option for COPY allowing to pipe data with an external program, both in input and output. This feature has been added in the following commit:

Measuring cascading replication lag in Postgres

2013-11-07 07:54:18 +0000

Based on the scripts developed in a previous post where a couple of hundred of Postgres servers were linked with replication cascading, let’s now have a look at the lag that cascading nodes have when creating several database objects.