Intel SSDs: Lifetime and the 320 vs. 710 Series

One of the most common questions here is “what’s the cheapest SSD I can put my database on?”, with the implied hope “…without losing it all the time“.

Global trends in deploying PostgreSQL

Talking to people deploying PostgreSQL in several countries during a short span of time has given me some interesting perspective on where the project is at.

Using the PostgreSQL System Columns

There are a few parts of the PostgreSQL internals that poke out usefully if you look in the right place for them.

Limitations removed in PostgreSQL 9.1

“How long should I wait before deploying 9.1?” - I have a very strong opinion on: you should consider 9.1 for new projects instead of 9.0.

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…

Indexando ando: Índices GIN

PostgreSQL tiene varios tipos de índices: B-tree, Hash, GiST, Gin y SP-GiST. Obviamente cada uno de ellos…

Announcing repmgr 2.0

Version 2.0 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new…

Announcing repmgr 2.0RC2

Version 2.0RC2 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new…

Row security in PostgreSQL – Overview

In the next week I will be writing a series of posts about the row-security work I’ve…

12345678