There is this idea that from 9.5 we will be able to upgrade pg clusters to newer, major, version, without downtime (well, almost), thanks to magic of logical replication. Sounds very promising, so I figured - I'll test it. To some ...

On 21st of October, Robert Haas committed patch: postgres_fdw: Push down aggregates to remote servers. Now that the upper planner uses paths, and now that we have proper hooks to inject paths into the upper planning process, it's possible for foreign data wrappers to ...

On 20th of October, Robert Haas committed patch: Rename "pg_xlog" directory to "pg_wal". "xlog" is not a particularly clear abbreviation for "write-ahead log", and it sometimes confuses users into believe that the contents of the "pg_xlog" directory are not critical data, leading to unpleasant consequences. ...

September 26th, 2016 by depesz | Tags: | No comments »

It looks that for some reason my subscription to pgsql-committers disappeared, and I stopped receiving mails from this list. I also didn't notice it, for some time - not sure when it got lost. I did resubscribed now, but if you can ...

Today, on irc, someone asked interesting question. Basically she ran a query like: select a, b, c, d, e, f from table order by a then, she processed the query to get, for each a array of unique values of b, c, d, ...

Lately at least two people on irc asked questions similar to "how do I know how many queries there are in database, per second?". So, let's see what we can find out.

Some time ago someone on irc asked about creating fast counters for something (banners I think). I talked with her (him?) about it, but figured, I can as well write a blogpost, so others can use it too.

Some time ago, I wrote blogpost about how to pick a task from queue, without locking. It was written in 2013, and as such it couldn't reflect everything we have now in PostgreSQL - namely SKIP LOCKED - which was added ...

On 8th of April, Alvaro Herrera committed patch: Support \crosstabview in psql \crosstabview is a completely different way to display results from a query: instead of a vertical display of rows, the data values are placed in a grid where the column and row ...

On 7th of April, Teodor Sigaev committed patch: Phrase full text search. Patch introduces new text search operator (< -> or ) into tsquery. On-disk and binary in/out format of tsquery are backward compatible. It has two side effect: - change order for tsquery, so, ...