It's not just Postgres. Nulls are weird and full of edge cases no matter what RDBMS you use. #postgres #postgresql
November 15, 2025 at 7:57 PM
It's not just Postgres. Nulls are weird and full of edge cases no matter what RDBMS you use. #postgres #postgresql
Nice post about AI suggesting "improvements" for a Postgrs table schema. But the part that made me LOL was the human comment starting with "Hopefully" :) stokerpostgresql.blogspot.com/2025/10/load... #postgres #postgresql
Loading The Titanic Passenger Data Into PostgreSQL With DBeaver Part 2
stokerpostgresql.blogspot.com
October 23, 2025 at 7:35 PM
Nice post about AI suggesting "improvements" for a Postgrs table schema. But the part that made me LOL was the human comment starting with "Hopefully" :) stokerpostgresql.blogspot.com/2025/10/load... #postgres #postgresql
Oh for Pete's sake, now there are some on the Postgres lists advocating *raising* random_page_cost default - by a lot! Crazy times. #postgres #postgresql
October 7, 2025 at 7:16 PM
Oh for Pete's sake, now there are some on the Postgres lists advocating *raising* random_page_cost default - by a lot! Crazy times. #postgres #postgresql
Working on some v19 features and managed to break my test Postgres instance worst than I ever have before. Every single SQL command causes the backend to crash. To be fair, I'm messing with the parser, but it's still a little jarring. :) #postgres #postgresql
October 5, 2025 at 2:54 PM
Working on some v19 features and managed to break my test Postgres instance worst than I ever have before. Every single SQL command causes the backend to crash. To be fair, I'm messing with the parser, but it's still a little jarring. :) #postgres #postgresql
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
September 8, 2025 at 3:25 PM
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
September 3, 2025 at 4:35 PM
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
September 1, 2025 at 5:47 PM
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
Postgres Logging for Performance Optimization | Crunchy Data Blog
Review key logging configurations in Postgres plus how to log key performance metrics.
www.crunchydata.com
August 22, 2025 at 3:29 PM
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
August 20, 2025 at 6:15 PM
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
Lies, Damn Lies, and LLM Output.
thebuild.com
August 14, 2025 at 2:22 AM
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
August 1, 2025 at 7:55 PM
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
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
July 30, 2025 at 2:19 PM
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
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
July 30, 2025 at 12:43 AM
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
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
byteofdev.com
July 28, 2025 at 2:51 PM
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
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.
www.rudderstack.com
July 24, 2025 at 8:16 PM
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
Who are the PGDG?
This article describes what the PGDG (PostgreSQL Global Development Group) is and how you can become a part of it.
www.cybertec-postgresql.com
July 22, 2025 at 5:16 PM
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
July 19, 2025 at 2:13 PM
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
July 15, 2025 at 1:28 AM
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
July 13, 2025 at 10:47 PM
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
July 10, 2025 at 6:58 PM
"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
July 10, 2025 at 4:39 PM
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
July 5, 2025 at 7:39 PM
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
July 2, 2025 at 9:59 PM
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!!!
https://vondra.me/posts/how-often-is-the-query-plan-optimal/There’s
June 30, 2025 at 2:53 PM
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
June 25, 2025 at 10:43 PM
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