Postgres 9.3 feature highlight - COPY FREEZE

2013-01-22 08:36:36 +0000

Continuing with the new features planned for PostgreSQL 9.3, here are some explanations about a new COPY mode called FREEZE. This feature has been introduced by this commit.

Postgres 9.3 feature highlight - custom background workers

2013-01-19 16:08:08 +0000

A new feature ideal for module makers is appearing in Postgres 9.3. Called “background worker processes”, this feature, which is a set of useful APIs, offers the possibility to create and customize worker processes called bgworkers able to run user-specified code directly plugged in the server. This worker is loaded and managed entirely by the server. So such processes can be considered as envelopped in a wrapper on top of the core code as a plug-in.

Postgres 9.3 feature highlight - auto-updatable views

2013-01-12 06:29:55 +0000

Prior to PostgreSQL 9.3, trying to execute a DML on a view results in an error. The view is not able to execute directly a query to its parent table. For example, you can see this kind of behavior in 9.2.

Postgres 9.3 feature highlight - timeline switch of slave node without archives

2012-12-25 14:44:32 +0000

Since PostgreSQL 9.1, it is possible to switch a standby server to follow another server that has been freshly promoted after the master node of a cluster is out due to a failure (disaster or another). In this example, a master and two slaves are running on the same machine. The master running with port 5432 fails, Slave 1 is promoted as the new master:

Postgres FDW highlight - redis_fdw

2012-11-28 03:54:09 +0000

A foreign-data wrapper (FWD) in a Postgres server allows to fetch data from an foreign entity or a foreign server. In this case, the Postgres planner and executer have the notion of what is called a foreign scan, which can be called using customized routines and fetch data that is not directly stored inside the Postgres server itself.