Andrew Dunstan's PostgreSQL and Technical blog

Today we're releasing a code for a small PostgreSQL module called plan_filter that lets you stop queries from even starting if they mee...

Yesterday I ordered a Raspberry Pi 2 Model B , and it should be delivered in a few days. I'm intending to set it up as a buildfarm membe...

The JSON type is not provided with any comparison operators built in, unlike the new JSONB type. One reason for this is that it's not re...

Taras Mitran has just published a blog post about using some of the advanced features of ECMAScript version 6 to make programming with SQL ...

I have released a new version of PLV8, which now builds on PostgreSQL 9.4, as well as containing a number of bug fixes. It can be download...

I got an idea the other day about how to get over the recent problem I had encountered with pg_repack colliding with a lock request on the ...

One of the things I was hoping would make it into PostgreSQL 9.4 and didn't was some extra statistics in pg_stat_statements. Specificall...

PostgreSQL 9.4 is released today, and once again my main input has been in the JSON area. We've introduced a new spiffy JSON type called...

While working on some customer code, I noticed that they have a lot of code that reads like this: SELECT a,b,c INTO foo.x, foo,y, foo.z; ...

I don't know how many times I have had to try to drum this into clients' heads. Having an up to date replica won't protect you a...

pg_repack is a terrific tool for allowing you to reorganize a table without needing to hold long running strong locks on the table. That mea...