“This book is on a higher level than generic software books. It explains the how's and why's of using Postgres's many feature. It is an excellent companion to the official Postgres documentation.” wrote Bruce Momjian about my book You have your copy yet?.

RT @TheArtOPostgres: The state of the art Cardinality Estimation Algorithm called HyperLogLog is available as a @PostgreSQL extension! Read….

What do you want to know?.

RT @robtreat2: Postgres 15 was released yesterday. Now that you've read the release notes and picked your favorite features, what questions….

RT @TheArtOPostgres: How to quickly find data matching a complex set of user provided tags, all within @PostgreSQL query engine, you may as….

RT @RiccardoOdone: @unamashana App devs are afraid of putting logic in SQL 🙂 @tapoueh ‘s The Art of PostgreSQL covers it well: https://t.co….

RT @TheArtOPostgres: How to Write SQL as code and maintain it the same way as the rest of your code checkout? Read more at .

RT @eulerto: Postgres 15 is almost ready. Let's check some changes that might break compatibility with previous releases: 🧵.

Final tweet in that thread: see if you're wondering about “a single command line per box, really?”. Yes, really. And you can reproduce that at home. The full Dockerfile and docker-compose.yml setup is provided.

Implementing these reference architectures require a single command line per box in many cases. See the docker-compose files in the tutorials. More architectures are possible, too, with quite some flexibility!

Implementing HA for Postgres is not easy. I am trying to implement all my tricks into pg_auto_failover to make it a smooth experience. Of course there are many things yet to be done. This is an Open Source project, open to contributions! You're welcome to join the fun ;-).

Also v2.0 because a lot of improvements and fixes have been made along the way. This includes our “dynamic console” pg_autoctl watch (it's like top, but for your Postgres HA setup). If you tried pg_auto_failover before and weren't convinced, now is a good time to try again!.

So v2.0 because first, Citus support. Main docs are available at and a full tutorial to get started easily with both Citus and pg_auto_failover HA for it is available at using docker-compose.

I am proud to announce release 2.0 of pg_auto_failover! With Postgres 15 support, and already in debian thanks to @df7cb amazing work. Get started at with the docs. You're looking to implement HA for Postgres? Try pg_auto_failover!.

RT @TheArtOPostgres: SQL Regression Tests

RT @robtreat2: FYI, if you were waiting till the proverbial last minute to do your Postgres v15 beta testing, the time has arrived 😉.

Just released pgcopydb v0.9 with lots of improvements and bug fixes. See Thanks to @df7cb packages are already uploaded to debian and all! Maybe @DevrimGunduz is next for the RPMs?.

RT @robtreat2: Interesting news (depending on your level of tech nerdy I suppose🤣); the @PostgreSQL project seems to have settled on a futu….

RT @TheArtOPostgres: The Most Popular Pub Names

RT @TheArtOPostgres: "In @PostgreSQL Data Types: Point we did download a complete geolocation data set and normalized it, making good use o….

RT @tchorix: @craigkerstiens I quite like @TheArtOPostgres and it's targetting developers.

RT @craigkerstiens: Taking a few minutes today to practice some SQL. Loving having the @crunchydata playground - an….