PostgreSQL 9.4 for administrators (part one)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

Ware Yosemite?

Possible issues with PostgreSQL after upgrades of OS X machines to Yosemite (OS X 10.10)

PostgreSQL 9.4 for administrators (part two)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

Japan PostgreSQL Conference 2014

Japan has been an early and vigorous adopter of PostgreSQL (back in 2006, when PostgreSQL was still…

BDR for PostgreSQL: Present and future

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working…

PostgreSQL 9.4 for administrators (part two)

  Written by Francesco Canovai First published in Italian    In the previous instalment, we introduced the logical…

Progress on online upgrade

In last couple of months I’ve been working on online upgrade for very large databases as part…

All-processes breakpoints / watchpoints for PostgreSQL

Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s…

Group photo PGDayIT

Italian PGDay, eight edition: over 120 attendees!

November 7th 2014 was the eight Italian PostgreSQL Day, the national event dedicated to the promotion of…

PostgreSQL 9.4 for administrators (part one)

Written by Francesco Canovai     Version 9.4 of PostgreSQL, soon to be released, has many innovations for…

… and now for something completely different!

Up until now, reading this blog has kept you up-to-date with the latest developments in PostgreSQL. This…

Ware Yosemite? Possible PostgreSQL upgrade issues in OS X 10.10

I’m seeing reports of a number of issues with PostgreSQL after upgrades of OS X machines to…

Index Overhead on a Growing Table

This another simple test in continuation from last time. We will start with the same lineitem table as…

Loading Tables and Creating B-tree and Block Range Indexes

I have been looking at the new Block Range Indexes (BRIN) being developed for PostgreSQL 9.5. BRIN indexes…

Compiling and debugging PostgreSQL’s PgJDBC under Eclipse

I’ve always worked on PgJDBC, the JDBC Type 4 driver for PostgreSQL, with just a terminal, ant…

pg_sysdatetime: a simple cross-platform PostgreSQL extension

A while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile…

Announcing BDR RPMs for 9.4

RPMs for BDR (Bi-Directional Replication for PostgreSQL) are now available for testing. They contain BDR release 0.7.1,…

Barman, backup and recovery manager for PostgreSQL

Detecting smelly backups with Barman

“Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd,…

Barman, backup and recovery manager for PostgreSQL

Announcing Barman 1.3.3

Version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.

123456789