On 20th of January, Peter Eisentraut committed patch: Logical replication - Add PUBLICATION catalogs and DDL - Add SUBSCRIPTION catalog and DDL - Define logical replication protocol and output plugin - Add logical replication workers From: Petr Jelinek Reviewed-by: Steve Singer Reviewed-by: Andres Freund Reviewed-by: Erik Rijkers Reviewed-by: Peter Eisentraut

On 20th of December, Peter Eisentraut committed patch: Add pg_sequence system catalog Move sequence metadata (start, increment, etc.) into a proper system catalog instead of storing it in the sequence heap object. This separates the metadata from the sequence data. Sequence metadata ...

Couple of people asked, on irc, about how to generate unique, short, ids for rows. Since I wrote code for this for explain.depesz.com, I figured that instead of pointing to sources, and letting everyone to extract the functions, I will, instead, ...

I had two month delay related to some work, but now I can finally write about: On 7th of December, Robert Haas committed patch: Implement table partitioning. Table partitioning is like table inheritance and reuses much of the existing infrastructure, but there are some ...

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.