Been working with a database that defaults to UPPERCASE for unquoted things, and wow, is that annoying after all these decades of calm, non-yelling lowercase Postgres code. :) #postgres #postgresql

Wondering if I should bother trying to raise the default track_activity_query_size in Postgres. It's been 1kb for a long time, and that seems too small for today's verbose apps, complex queries, and ORMs. #postgres

Inspired by a Slack discussion, here's how to tell how many of today's 86,400 seconds have been used up already: select round(extract(epoch from now() - 'today'::date)); #postgres

Awesome blog post on Postgres logging from my colleague @sqlliz.bsky.social www.crunchydata.com/blog/postgre... #postgres #postgresql

Use of domains came up on Postgres lists recently. I very seldom use them, always seems better to just use check constraints on a base type. Still more useful than enum however! #postgres #postgresql

Yikes. Another crappy blog written by LLM spotted and slammed: thebuild.com/blog/2025/08... I'm not convinced the comment replies are not LLM as well. #postgres #postgresql

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

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

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

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

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

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

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

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

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

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

Hilarious that sometimes Postgres has things like a "xact_start" column to save space rather than writing out "transaction_start" but then also has a column named "result_cast_numeric_precision_radix" and a function called "binary_upgrade_set_next_multirange_array_pg_type_oid" #postgres

Reminder: pg_last_xact_replay_timestamp() and similar are at the mercy of your primary actually making changes that generate WAL. Cron up something lightweight for low-activity times! #postgres #postgresql

Nice to see local Postgres meetups happening like this: hdombrovskaya.wordpress.com/2025/05/26/p... #postgres #postgresql #planetpg

Happy to report that statistics will NOT be dumped by default in Postgres 18. It will be the default for pg_upgrade, of course. #postgres #postgresql #battlewon

Interesting numbers here on speed of pg_dump. I wonder if the query consolidation improvements in v18 are responsible for the digression simply because of the number of objects dumped in this example? Might dig into that. www.depesz.com/2025/05/22/p... #postgres #postgresql

Great writeup on the just-finished Postgres developers conference for 2025: hornetlabs.ca/2025/05/21/p... #postgres #postgresql

Interesting observation I just posted to the lists: pg_dump is designed to give zero errors, while pg_dumpall always gives at least one error. #postgres #postgresql

This is a cool series: focused on non-technical contributions to the Postgres community. Here is the latest: postgres-contrib.org/post/41/ #postgres #postgresql #planetpg

Random idea: flag to let pg_basebackup set a specified port for the replica. I find myself doing that a lot, although TBH probably because I test replicas on the same box. #postgres #postgresql

www.infoworld.com/article/3982... I thought this was a nice article in a "okay grandma, we know you were important back in the LAMP days" kind of way. #postgres #postgresql

Nice explanation of the asynchronous I/O work that has been happening for Postgres: pganalyze.com/blog/postgre... Also interesting to see poor little effective_io_concurrency become a lot more useful! #postgres #postgresql #planetpg

Hm....pg_dump with statistics on seems to have slipped into 18 beta. Pushing back on that, because I think it's a great idea for pg_upgrade, but a bad idea as default for pg_dump. #postgres #postgresql

Looking through the options for psql, the amazing Postgres CLI, I realized that in over 20 years, I have never, ever used the -z and -0 options. Every other option I have used, even if rarely. #postgres #postgresql

New for Postgres v19: regdatabase. About time! #postgres #postgresql

www.pgedge.com/blog/unleash... Nice to see multi-source databases still being done, many, many years after Bucardo #postgres #postgresql

Might be time to take a break from hacking on Postgres for today. Kept wondering why I couldn't open storage/buffer/bugmgr.c :) #postgres #postgresql