Archiwizowane December, 2012

So, you just installed your PostgreSQL, and you have no idea how to use it - there is no icon in the menu of your OS, so how can you use it? Well, with the dreadful command line. Of course - ...

On 13th of December, Heikki Linnakangas committed patch: Allow a streaming replication standby to follow a timeline switch. Before this patch, streaming replication would refuse to start replicating if the timeline in the primary doesn't exactly match the standby. The situation where it doesn't ...

On 8th of December, Tom Lane committed patch: Support automatically-updatable views. This patch makes "simple" views automatically updatable, without the need to create either INSTEAD OF triggers or INSTEAD rules. "Simple" views are those classified as updatable according to SQL-92 rules. The ...

December 9th, 2012 by depesz | Tags: , , , , , , , | 2 comments »

In PostgreSQL 8.4 we got CTE - Common Table Expressions. Since then we have this great tool available, but apparently for some people it's still black magic. CuTE, but still magic. I'll try to make it a bit less magical, ...

On 6th of December, Alvaro Herrera committed patch: Background worker processes Background workers are postmaster subprocesses that run arbitrary user-specified code. They can request shared memory access as well as backend database connections; or they can just use plain libpq frontend database connections. Modules listed ...

Some of you might be familiar with pgBouncer project. Some are not. Some understand what/how/why it does, others do not. This blog post is to have a place where I can point people who have question about how it works, why, ...