Postgres is great. There are a ton of reasons to use it. But, can it be misused and abused? Oh it sure can, my colleague Karen Jex (she/her) has some fun looking at ways in this great talk youtube.com/watch?v=rA4J3k…

New semester of CMU Database Group's Intro to Database Systems! We're back with vengeance with new lectures on vector/full-text indexes + distributed databases! Also featuring 10min flash talks each Wednesday from leading DB companies! You can follow along on YouTube. 15445.courses.cs.cmu.edu/fall2024

This paper is worth reading and I look forward to more research in this space. We need better b-trees to navigate more of the read, write & space-amp tradeoffs explained in the Rum Conjecture paper. Thank you Xiangpeng Hao and Badrish Chandramouli

Seattle Postgres User Group kicking off the fall season with a talk about pgBouncer password rotation without pg_shadow access. If you want to hang out with some Postgres database geeks in Seattle, this is the place to be on Thu Sep 5. eventbrite.com/e/secure-pgbou…

IIUC partitioning was historically the widest use case for Postgres inheritance. I'm not sure Oracle Object table inheritance is quite the same. Any Postgres users out there making heavy use of inheritance for reasons other than legacy partitioning? If so, whats your use case?

This is great A dictionary of the Postgres mailing lists & dev community All the abbreviations and acronyms and phrases I can confirm the jargon is all real crunchydata.com/blog/understan…

I love the "10 stops away" notification on my phone - then click & see it on a map - for something I ordered yesterday on Amazon! Feels so gratifying! Database internals matter a lot, but so does the user/admin experience That's basically what this whole podcast was about 💯🎯

this Nik Samokhvalov guy and his PostgresAI assistant are a sight to behold looking at the transcript and this is pretty amazing

How do you typically set up a local Postgres dev environment and why? I use Docker because it can easily start/stop/recreate database server(s). There are also many pre-built images if I want to use extensions like pgvector or plv8. I also see people using a local Postgres

Shayon Mukherjee (Shayon Mukherjee): pg_easy_replicate Now Supports Tracking Schema Changes in PostgreSQL postgr.es/p/6Cv

What happened with PartiQL?

The 2nd CommitFest of Postgres 18 starts today. I noticed an increase in performance-related patches. The chart below shows the top 5 topics from the last decade of CFs. We've had ~40 performance patches committed per year < 2024. This year we've had 64 already with 2 CFs to go!

PostgreSQL is the ultimate “I gotchu fam” database. Rock solid relational foundation with an ever growing ecosystem of extensions for every specialized workload under the sun. Long Postgres 📈

If you're coming to see us (Oracle Database) in Vegas next week - bring your work and tech challenges with you. We can help! Find us, stop us, ask us Maria Colgan Gerald Venzl 🚀 dominic_giles krisrice 🏒🍺📷 Tirthankar Lahiri Jenny Tsai-Smith Kay Malcolm

The 2024 edition of the State of Postgres survey is out - Props to Timescale for organizing 👏 form.typeform.com/to/wtUFIZwA Let's learn about the Postgres community:

Things are getting serious... PostgreSQL 17 RC1 Released! postgresql.org/about/news/pos…

Great technical blog from Neon; design details and tests toward estimating database working set size. Must read! ❤️ the graphs showing size over window duration. Too bad that the AWS serverless v2 paper says nothing about the approach they took... (also HLL? Marc Brooker ?)

Still thinking on this. Is the IaC idea working for databases? If you want to failover to a standby instance, or PITR to a temp copy, or a DB major version upgrade... is editing a terraform or ansible file actually the right model? I can't decide if there's impedence mismatch.

wait events #FTW ... during the whole max_conn and USE discussion i was thinking: "wait events gives you a quick understanding from one chart" then he said it 🙂 (35min) forgot discussion link gitlab.com/postgres-ai/pg… love the numbered dashboards - stock pgwatch doesnt have this

Really interesting work from Peter Geoghegan . Fun/stupid fact: I nibbled at this 10 years ago, when only two popular databases lacked the optimisation, and discussed it with a fellow database hacker, starting a chain of events that left us as the only database without it!