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.
Read more...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:
Read more...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.
Read more...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:
Read more...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.
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.