GSM
Postgres. Lots of Postgres.
- 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
- Postgres v18 release notes are starting to form up! www.postgresql.org/docs/devel/r... I got 3 items in this release... #postgres #postgresql
- 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
- Heh - locked myself out of my replica because of a login (auditing) trigger. Easy enough to fix but wondering about workarounds - maybe the function checks pg_is_in_recovery()? #postgres #postgresql
- Musing on the list about Postgres TDE, which would be an example of a rare "radically change the way we store things" and thus make pg_upgrade not so useful anymore (for the initial migration anyway). #postgres #postgresql
- 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
- Nice workaround for when you don't have \password: using a Perl script to create a SCRAM password to feed directly to Postgres. www.leader.it/Blog/Postgre... #postgres #postgresql
- Postgres v18 now has all the features it is going to have, so awaiting the inevitable "what's new in Postgres 18" posts to start sprouting. Don't make me write my own! (guess I could post mini-articles here...) #postgres #postgresql
- It's getting harder every year to compile old versions of Postgres. At some point, I may have to give up on some of these, or use some container tech. (old =~ v7.x and 8.x) #postgres #postgresql
- Interesting discussion on Postgres -hackers mailing list about adding RAFT (or similar) inside Postgres. I think it's a non-starter for a lot of reasons, but will be fun to see the arguments being made! #postgres #postgresql
- Event triggers in Postgres (www.postgresql.org/docs/current...) are becoming one of my favorite "new" features. Probably will submit patches in the next couple years to make them even better, as I poke into the corners of it. #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
- Wow, it is pretty clear that using AoE (en.wikipedia.org/wiki/Anywher...) was a bad idea for Postgres commit freeze. Seems an overwhelming consensus now to just use UTC. AoE is really kind of dumb for stuff like this, which already has a squishy deadline and a long lead time. #postgres #postgresql
- 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
- The final flood of commits for v18 has begun! #postgres #postgresql
- 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
- Cool Postgres trick here: www.cybertec-postgresql.com/en/debugging... I don''t use table inheritance (not terribly useful) but I do use the hidden column tableoid a good bit (especially for partitioned tables) #postgres #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
- Decided to add a new one to my list of tilting at windmills Postgres goals: renaming pg_hba.conf to … something else. Frankly anything would be better. #postgres #postgresql
- I use \o in psql so often I forgot the command-line options exist! stokerpostgresql.blogspot.com/2025/03/savi... #postgres #postgresql
- Cool post by Kaarel Moppel about startup vars to psql for (among other things) a read-only session: kmoppel.github.io/2025-03-27-t... My favorite part: "created by our robot-friends". That's a big problem that is not going away! #postgres #postgresql
- So nice seeing some Perl pop up on Planet Postgres! Like bumping into an old friend at the airport. domm.plix.at/perl/2025_03... #postgres #postgresql #perl
- Interesting article on SQL Server vs Postgres (redmondmag.com/Articles/202...) I think it's an honest attempt, but it doesn't in my eyes make a very good case for SQL Server, and has a few errors. 🧵
- Latest Postgres person of the week: postgresql.life/post/shruthi... (one of the best bio pics ever!) The number of questions has expanded a good bit since I did mine! #postgres #postgresql
- Just ordered my copy of "PostgreSQL Mistakes and How to Avoid Them" by @vyruss.org Going to try and wait for the physical copy. #postgres #postgresql (Got nudged again on this by this recent blog post: vyruss.org/blog/scale-2...)
