toad.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server operated by David Troy, a tech pioneer and investigative journalist addressing threats to democracy. Thoughtful participation and discussion welcome.

Administered by:

Server stats:

309
active users

#postgres

6 posts4 participants0 posts today
Continued thread

Pro tips:
1. Use INT or BIGINT with sequences when you don't need globally unique IDs
2. If you need UUIDs, prefer UUIDv7 over UUIDv4 to minimize index bloat and performance issues
3. Consider UUIDv4 when you absolutely need maximum randomness and unpredictability, but for most UUID use cases, UUIDv7 provides a better balance of uniqueness, distribution, and database performance.

Continued thread

2. PostgreSQL 18 adds support for UUIDv7 generation through the uuidv7() function, letting you generate random UUIDs that are timestamp-ordered to support better caching strategies (this release also adds uuidv4() as an alias for gen_rand_uuid).

Support for UUIDv7 means we should see much less index bloat and performance loss when we use UUID on primary keys and index fields.

The Postgres folk are innovating at a pace that is hard to keep up with! I want to call out two features in the 18 beta release that I'm excited about:

1. PostgreSQL 18 introduces an asynchronous I/O (AIO) subsystem. This initial release supports file system reads such as sequential scans, bitmap heap scans, and vacuums, with tests showing up to 2-3x performance improvements.

StatsMgr is a standalone #Postgres extension that creates structured snapshots of internal metrics (e.g. WAL, checkpoints, SLRU) w/ background workers & shared memory, then exposes them via a simple SQL API.

What do you think?

➡️ Is this useful for your #observability tooling?
➡️ Should parts of StatsMgr be proposed for core inclusion?

🖥️ Check it out on #Codeberg: codeberg.org/Data-Bene/StatsMg

📚📹 Learn more: data-bene.io/en/blog/postgres-

This week the annual @pgconfdev development conference is happening, this time in Montréal—and it's great to be back together with #PostgreSQL folks, to catch up with Microsoft teammates, & to prep for my talk tomorrow. The talk is titled: "What 10 Postgres major contributors did to become a hacker" and it's built from stories and insights from some of the Postgres developers who have come on the #TalkingPostgres podcast I host each month.

If you're at this amazing conference, I hope you can join me. (Sneak peek of the cover slide attached 👇)

Boriss Mejías and I just finished recording our storytelling session about the advantages of data modeling (in #PostgreSQL, but applies for any relational database) for @posetteconf ! 🐘

When it's live, you'll be able to hear him mention "no animals were harmed during the making of this video" - that's because Mama Lily here is in my recording room with her baby bunnies, and they enjoy pretending to be a construction crew at all times.

Their toys were removed just for the talk so they took a nap, and everything was put back - so everyone went right back to having fun ☀️

Register for POSETTE (or keep an eye out for the recordings!) here: lnkd.in/gQbQe4qJ

Or check out my rescue Two Rabbit Rescue on Instagram (@2rabbitrescue), Mastodon (@2rabbitrescue@mastodon.social), or Facebook (@two-rabbit-rescue) to keep an eye out for when Mama Lily and her kids are adoptable 💕 (or if you just want to see more bunny cuteness!)

tworabbitrescue.org

New episode of the #TalkingPostgres #podcast 🎙️

In Ep27, Peter Farkas of @ferretdb shares how a Himalayan trek led to building an open source MongoDB alternative on top of #PostgreSQL (& the newly-open sourced DocumentDB extension from Microsoft)

Plus: FerretDB was NOT the original name. And how Trappist cheese 🧀 now gets a footnote in database history.

Listen wherever you get your podcasts. And if you like the show PLEASE tell your friends 🚀 so they can discover it too ❤️

#database #FerretDB #Postgres #OpenSource #Community #NoSQL #Microsoft

🎧 talkingpostgres.com/episodes/h
📺 youtu.be/dQfD00bDMqo?feature=s

What's new with Postgres at Microsoft? The 2025 edition of our annual blog post is now live.

Over the past year, the team at Microsoft who work on Postgres has contributed across multiple fronts:

🛠️ New features in Azure Database for PostgreSQL - Flexible Server
🧠 Code contributions to Postgres 18 (including async I/O!)
📦 Open source work on the Citus extension
🌍 Contributions to the Postgres open source community—things like @posetteconf, helping make @pgconfdev happen, the Talking Postgres #podcast, and sponsoring #PostgreSQL conferences around the globe

This year's blog post includes a hand-made infographic that maps out the major workstreams—plus highlights, explanations, links, and shout-outs to some of the many people behind the work.

If you care about PostgreSQL—as a user, contributor, or fan—I hope you'll give it a read.

📝 Read the full blog post on Microsoft Tech Community: techcommunity.microsoft.com/bl

Mattermost is an open source platform for developer collaboration that can be installed from Flathub. Mattermost is an alternative to SaaS collaboration solutions. Mattermost is built explicitly for developer teams, tools, and workflows. It is written in Golang and React and runs as a production-ready Linux binary under an MIT license with either MySQL or Postgres.

Flathub
flathub.org/apps/com.mattermos