Andrew Dunstan's PostgreSQL and Technical blog

  I have just pushed Release 13.1 of the PostgreSQL BuildFarm client. This update to Release 13 fixes errors that occur from the new defaul...

I have pushed Release 13 of the PostgreSQL BuildFarm client. Change highlights: add tests for a few cases that were previously missin...

Recent discussion set me thinking about what would be involved in setting up standalone TAP tests for Postgres, to do, say, more code covera...

In keeping with modern git practice, I have renamed the default branch on both the client-code and server-code repositories to main . If y...

It's possible to use EXPLAIN output in plpgsql. In the default text format, the result comes back as a set of text values, so you can pr...

With one very small exception, there is nothing in the buildfarm server that requires the client to be running perl, even though both the se...

I just discovered after a great deal of puzzlement and far too much time that if you run multiple instances of Postgres on a machine, and yo...

Common Table Expressions are a wonderful thing. Not only are they indespensible for creating recursive queries, but they can be a powerful t...

I just committed a patch to allow building with Visual Studio 2015. Due to a change in the way we need to detect locales with this compiler,...

I needed to get a DLL prepared of my tiny closed format ranges extension , and so I tried following the excellent instructions Craig Ringer ...

Five days ago, my buildfarm animal jacana suddenly started getting an error while trying to extract typedefs. It had been happily doing this...

GIN indexes of arrays can be pretty useful. And arrays of enums can also be pretty useful. Unfortunately, there is no built in GIN indexing ...