Call for papers for PGDay.IT has been extended

The new deadline for submitting a paper for the 6th edition of the Italian PGDay is October 7. International speakers are more than welcome to submit their proposal through the...
September 29, 2012

The "French Revolution"

When Damien Clochard from the French/European Community of PostgreSQL posted this message in the Advocacy list of PostgreSQL, I could not believe my eyes. I felt like years of promotion...
September 25, 2012

CTE and the Birthday Paradox

An interesting query has been twitted by Will Leinweber from Postgres Open: -- this returns a different result each time it is ran with recursive s as ( select random()...
September 20, 2012

Managing useful clusters with repmgr

To create a standby in PostgreSQL is relatively easy , and because of the hot standby feature , that alone is certainly very useful. But creating a useful cluster that...
August 29, 2012

Submit your talk for PGDay.IT

The sixth edition of the Italian PGDay will be held in Prato on November 23 in the historical location of the Monash University Centre. The call for papers has officially...
August 27, 2012

Management of the WAL archive in Barman

Barman, backup and recovery manager for PostgreSQL, is designed to manage the archive of WAL files separately from periodical backups (in Postgres terms, base backups). You can see this archive...
August 22, 2012

Barman is finally out

It took longer than expected, but we have finally managed to release Barman as open-source under GNU GPL 3. Barman stands for “ Backup and Recovery Manager” and it is...
July 24, 2012

Greenplum CE 4.2 XML support

In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support. Introduction This article has an educational goal. Most likely you will...
July 23, 2012