OmniDB: Monitoring Dashboard

OmniDB 2.4.0 introduces a new cool feature called Monitoring Dashboard. We know a picture is worth a thousand words, so please take a look: As you can see, this is...
February 08, 2018

PostgreSQL Developer Meeting Brussels

The PostgreSQL Developer Meeting went well with attendees from UK, Czechia, US, Russia and Germany. The meeting is in Brussels, near the FOSDEM conference. Andreas Seltenreich was the new face...
February 02, 2018

Using Multimaster and BDR appropriately - LinuxConfAu

Unless you were in Sydney for linux.conf.au 2018 last week you probably didn’t see my talk Geographically distributed multi-master replication with PostgreSQL and BDR. Luckily for you it’s on archive.org...
February 01, 2018

PG Phriday: Adventures in BAR Management

Backups are a critical component to a fully covered Postgres database infrastructure. In some ways, it’s fair to say a database without a backup is no database at all—sometimes literally...
January 19, 2018

PostgreSQL Meltdown

Spectre and Meltdown have caused severe alarm in recent days. You may have read about up to 30% impact on PostgreSQL databases, which I believe to be overstated because of...
January 10, 2018

PostgreSQL is the DBMS of the Year 2017

The annual DBEngines ranking have just been updated, with PostgreSQL winning the “DBMS of the Year 2017” award. http://db-engines.com/en/blog_post/76 PostgreSQL was a runner up last year. http://db-engines.com/en/blog_post/67 So across the...
January 10, 2018

Buildfarm Client Bugfix Release 6.1

I have released version 6.1 of the PostgreSQL Buildfarm client. It is available at http://buildfarm.postgresql.org/downloads/releases/build-farm-6_1.tgz This release fixes a couple of bugs that became apparent in yesterday’s release. The first...
January 05, 2018

Announcing Release 6 of PostgreSQL Buildfarm client

PostgreSQL Buildfarm client Release 6 is now available and can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-6.tgz Features use a persistent cache for configure, leading to a substantial performance improvement for that step...
January 04, 2018

PG Phriday: Postgres on ZFS

ZFS is a filesystem originally created by Sun Microsystems, and has been available for BSD over a decade. While Postgres will run just fine on BSD, most Postgres installations are...
December 29, 2017