Planet PostgreSQL

Planet PostgreSQL

Hubert 'depesz' Lubaczewski: Waiting for 9.2 – pg_basebackup from slave

February 3, 2012, 9:08 am
On 25th of January, Simon Riggs committed patch: Allow pg_basebackup FROM standby node WITH safety checking. Base backup follows recommended PROCEDURE

Jared Watkins: What I Do – Broadsoft CDR Files to Radius Accounting Records

February 2, 2012, 10:40 pm
As part of a larger project I needed to generate real time radius records from the CDR accounting files of several cluster pairs of Broadsoft applicat

Bruce Momjian: Let's See work_mem

February 2, 2012, 10:45 am
Having shown memory allocation (and deallocation) in my previous blog post, I would like to show work_mem in action. First, I ran the following datab

Hubert 'depesz' Lubaczewski: Waiting for 9.2 – Trigger Depth

February 1, 2012, 12:36 pm
On 25th of January, Alvaro Herrera committed patch: ADD pg_trigger_depth() FUNCTION   This reports the depth level OF triggers currently

Jim Smith: Why aren't more people/companies using PostgreSQL?

February 1, 2012, 11:58 am
Why aren't more people/companies using PostgreSQL? Why aren't they moving from proprietary databases to PostgreSQL?  Possible answers: I haven't

Bruce Momjian: Postgres Memory Surprises

February 1, 2012, 10:15 am
In my previous blog entry, I analyzed how various tools (ps and smem) report memory usage. In summary: ps columns TRS, DRS, and VSZ report virtua

Hubert 'depesz' Lubaczewski: Waiting for 9.2 – ALTER IF EXISTS

February 1, 2012, 8:14 am
On 23th of January, Simon Riggs committed patch: ALTER <thing> [IF EXISTS] ... allows silent DDL IF required, e.g. ALTER FOREIGN TABLE

Pavel Golub: Factorial using CTE in PostgreSQL

February 1, 2012, 4:42 am
Not so long ago I used Common Table Expressions for Fibonacci Numbers calculation. Today I had a conversation with one client about SQL in general and

Damien Clochard: Write a Foreign Data Wrapper in 15 minutes (Part 1/2)

January 31, 2012, 5:49 pm
Among the long list of new features of PostgreSQL 9.1 the new SQL/MED implementation is probably of the most underrated. SQL/MED is an extension of th

Greg Smith: Using the PostgreSQL System Columns

January 31, 2012, 5:02 pm
There are a few parts of the PostgreSQL internals that poke out usefully if you look in the right place for them.  One useful set to know about a
Adding an RSS Feed from a favorite site is a snap and takes only a few button clicks.  This feed is from the Postgresql site which is very active with many experts contributing from around the world.  Younicycle is built on PostgreSQL.