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.

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…

Streaming replication slots in PostgreSQL 9.4

Streaming replication slots are a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction…

devops with Postgres

Managing PostgreSQL in a devops environment

With every new release, PostgreSQL gets better at addressing the needs of developers, database and system administrators….

Announcing repmgr 2.0RC1

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

Barman, backup and recovery manager for PostgreSQL

Announcing Barman 1.3.0

Version 1.3.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, making the tool more…

Compiling PostgreSQL extensions with Visual Studio on Windows

I’ve seen a number of users struggling with building PostgreSQL extensions under Visual Studio, so I thought…

Enterprise Support – The final hurdle for PostgreSQL?

It’s been an interesting 9 months for me personally, joining the 2ndQuadrant team in April 2013 to…

PostgreSQL guts: What is “resjunk”?

I’m delving into the PostgreSQL parser, query rewriter and query planner at the moment, as part of…

Security Barrier

How do PostgreSQL security_barrier views work?

You might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into…

123456789