GSM

Getting down to the finish line - hope my "initdb checkpoints on by default" patch and its cousin "don't dump stats to pg_dump by default" both survive as is! #postgres #postgresql

Postgres tip of the day: you can chain psql -c calls:

psql -c 'alter system set random_page_cost = 1.5' -c 'select pg_reload_conf()'

Bonus: they run in the same session, so you can even use vars.

#postgres #postgresql

Not happy with all the ads and pseudo-ads popping up on Planet Postgres... #postgres #postgresql

Making Postgres 42,000x slower because I am unemployed As an respectable unemployed person must do, I tried to make Postgres as slow as possible

Amazing post on making Postgres slower (yes, slower!) on purpose. byteofdev.com/posts/making... #postgres #postgresql Favorite bit: "random_page_cost = 1e300" LOL! Well done

Lessons from scaling PostgreSQL queues to 100K events This post is a chronicle of the critical, hard-won lessons learned while maturing PostgreSQL into a highly performant and resilient queuing system.

Great article at www.rudderstack.com/blog/scaling... about getting Postgres to scale. My only objection would be the lowering of checkpoint_timeout; better to rely on a failover replica than worry about WAL replay. #postgres #postgresql

Who are the PGDG? This article describes what the PGDG (PostgreSQL Global Development Group) is and how you can become a part of it.

Nice article about what exactly is the PGDG (Postgres Global Development Group). My sv is "anyone who directly (and knowingly) helps the project in any form". www.cybertec-postgresql.com/en/who-are-t... #postgres #postgresql #planetpg

Postgres making some more progress towards not supporting 32-bit stuff. Or at least making our code less painful to work with it. Even Raspberry Pi can do 64-bit these days! #postgres

Pro tip: use long args when sending example commands to someone; less likely they will get it wrong. psql -X vs. psql --no-psqlrc As a bonus, it's usually a lot more self-documenting as well. #postgres

Interesting thread on -hackers about Postgres resizing shared_buffers on the fly (smaller to larger only!). Looks quite feasible, I think it will make it into v19 #postgres

"While the Postgres community has an older and sometimes daunting contribution process of submitting patches to a mailing list..." (from clickhouse.com/blog/sigterm...). Okay, guilty as charged. :) #postgres

Love this post about active-active Postgres replication and reasons not to do it: percona.community/blog/2025/07... The best one is #4 (because other systems did it). If I had a nickle for every time I heard "but Oracle...." #postgres #postgresql

Fascinating discussion about Postgres and the use custom/generic plans (if you have been to my training, you know about this and the magic number 5). danolivo.substack.com/p/on-postgre... #postgres #postgresql #planetpg

This is a good post about UUIDs in Postgres at andyatkinson.com/constraint-d... but the name is too long - "Avoid UUID Version 4 Primary Keys" can really be shortened to "Avoid UUID" :) #postgres #postgresql

Good Postgres post on how often the optimizer is "correct": vondra.me/posts/how-of... #postgres #postgresql #planetpg Key qyote: "There’s also the question of the cost model itself, which is a very rough approximation of the hardware behavior" - I'm looking at you again, random_page_cost!!!

Woah - did not expect to see vectors in the (still future) SQL standard, but there it is: peter.eisentraut.org/blog/2025/06... #postgres #planetpg #postgresql

Cannot resist reposting this: devclass.com/2025/06/24/s... #postgres #postgresql

Nice article on SELECT FOR UPDATE in Postgres at www.cybertec-postgresql.com/en/select-fo.... I take issue that plain FOR UPDATE is "harmful" or "wrong", but I get the point about only taking the locks you actually need. Would be nice if NO KEY UPDATE was default. #postgres #planetpg #postgresql

I know pg_hba.conf is ugly, but compared to mysql's auth system, it works very well indeed. #postgres

As the author of one of the earlier multi-master systems, posts like percona.community/blog/2025/06... are always interesting to me. #postgres #postgresql My take: it is not needed 99.99% of the time, despite what people insist.

Ugh, that -hackers thread in which RHEL8 keeps getting labelled as an "old OS". It ain't dead yet! #postgres #rhel

Preserve optimizer statistics during major upgrades with PostgreSQL v18 This article highlights the new PostgreSQL v18 feature for keeping the optimizer statistics during a major upgrade.

Nice article about pg_upgrade finally preserving statistics in Postgres: www.cybertec-postgresql.com/en/preserve-... Parts of this were quite contentious. Hopefully, v18 lands with sensible defaults. #postgres #postgresql

Avoiding Timezone Traps: Correctly Extracting Date/Time Subfields in Django with PostgreSQL | Caktus Group Learn to avoid a common timezone pitfall in Django and PostgreSQL. See why using EXTRACT with AT TIME ZONE on a date type can lead to incorrect results and how session timezones can unexpectedly shift...

www.caktusgroup.com/blog/2025/06... tl;dr don't use Django. j/k just be careful with it. #postgres #postgresql

Random idea: make psql smart enough to give feedback for long-running queries like CREATE INDEX as we have pg_stat_progress* #postgres #postgresql

Contributions for the week of 2025-06-02 (Week 23) Contributions for the week of 2025-06-02 (Week 23) | PG Day France 2025 took place on June 3 and 4 in Mons, Belgium, organized by Leila Bakkali, Matt Cornillon, S…

postgres-contrib.org/post/44/ #postgres #postgresql

Using regular expressions and arrays in PostgreSQL Learn how to combine the usage of regular expressions and arrays in PostgreSQL into a more powerful technology through this blog post.

Nice little post about arrays (which I love and hate in Postgres): www.cybertec-postgresql.com/en/using-reg... #postgres #postgresql

Tom and myself and others are now Snowflakes

Well, it was certainly an interesting week for me in Postgres land! #postgres

tgl quote of the day "RLS is a
performance killer" So true. Fast, secure, pick one. #postgres #postgresql

www.postgresql.org/message-id/C...

Made my craziest patch idea yet to -hackers today. #postgres #postgresql