PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving...
Written by Giuseppe Broccolo Since PostgreSQL 9.3, it is possible to update and insert into views directly, so long as the view refers to only one underlying table. PostgreSQL 9.4...
Japan has been an early and vigorous adopter of PostgreSQL ( back in 2006, when PostgreSQL was still emerging from obscurity in the western hemisphere, I noted that in Tokyo...
For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become...
Written by Francesco Canovai In the previous instalment, we introduced the logical replication feature which has been added to PostgreSQL 9.4. Let’s go on exploring the multitude of new features...
In last couple of months I’ve been working on online upgrade for very large databases as part of the AXLE project and I would like to share my thoughts on...
Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s being changed by some unknown backend at some unknown time. Or a function...
November 7th 2014 was the eighth Italian PostgreSQL Day, the national event dedicated to the promotion of the world’s most advanced open source database. The Italian edition is one of...
Version 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of...
Up until now, reading this blog has kept you up-to-date with the latest developments in PostgreSQL. This time I would like to invite you to meet the team of 2ndQuadrant...
