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)

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.

PostgreSQL anti-patterns: read-modify-write cycles

Shaun Thomas’s recent post about client-side loops as an SQL anti-pattern is well worth a read if…

keep-calm-and-take-a-hint

PostgreSQL’s CTEs are optimisation fences

As part of AXLE project work I recently found myself re-examining issues around optimisation fencing and non-semantic…

Putting a PostgreSQL tablespace on a ramdisk risks ALL your data

I periodically see people being advised to put their tablspaces on RAM disks or tempfs volumes. This…

Barman, backup and recovery manager for PostgreSQL

Announcing Barman 1.3.1

Version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman now supports concurrent…

123456789