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
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
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
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
Nice to see local Postgres meetups happening like this: hdombrovskaya.wordpress.com/2025/05/26/p... #postgres #postgresql #planetpg
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
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
Very interesting article from @pgdba.org at pgdba.org/post/2025/04... Love the Tron imagery, although the elephant came out better than the penguin! #planetpg #postgres #postgresql
andyatkinson.com/source-code-... Was kind of expecting some examples of the logged queries. I've definitely done a similar trick in other languages, to embed where the query is coming from into a SQL comment. #postgres #postgresql #planetpg
postgresql.life/post/adam_he... Another interview for the Postgres person series. Luckily they started with v7/v8. I'm going to feel so old when an interview happens someday with someone starting on v16 :) #planetpg #postgres #postgresql
kuntalgh.blogspot.com/2025/04/expl... says "Disclaimer: This blog post is partially generated by AI." While I appreciate the transparency, was AI really needed for this? It's a short and not particularly useful or interesting post. #postgres #postgresql #planetpg
www.cybertec-postgresql.com/en/type-alig... Nice article about alignment in columns. Shame the thumbnail does not show the opening illustrations, it's one of his best so far, IMHO. #planetpg #postgres #postgresql
Great post about Postgres scaling: kmoppel.github.io/2025-04-10-p... #postgres #postgresql #planetpg
momjian.us/main/blogs/p... Interesting article from Bruce about a major advantage to open source software. #postgres #postgresql #planetpg
Planet Postgres: www.cybertec-postgresql.com/en/pgai-impo... Interesting blending of three of my favorite tech things: Postgres, Wikipedia, and AI. #postgres #postgresql #planetpg
Planet Postgres: notso.boringsql.com/posts/know-t... Fantastic article all about timestamps, intervals, and other time-related gotchas. #postgres #planetpg #postgresql (tl;dr always use timestamptz, never timestamp)
Planet Postgres: postgrespro.com/blog/pgsql/5... in which some new Postgres v18 (coming later this year) additions are discussed, including the amazing idea of turning on checksums by default :) #postgres #planetpg #postgresql
Planet Postgres: thebuild.com/blog/2025/04... Sounds advice! No need to ever open any ports to the world (and especially my favorite one), except when absolutely necessary. #postgres #postgresql #planetpg
Planet Postgres: My friend @karenhjex.bsky.social talks about Kubernetes - which I need to get better at! karenjex.blogspot.com/2025/04/post... #postgres #postgresql #planetpg
Planet Postgres post on PG person-of-the-week Akshat Jaimini: postgresql.life/post/akshat_... +1 for the mention of Dune Messiah #planetpg #postgres #postgresql
Planet Postgres: okbob.blogspot.com/2025/03/how-... in which once again programs write bad SQL (I'm shocked, shocked I tell you) #postgres #postgresql #planetpg
