1
Postgres UUIDv7 and per-back end monotonicity
How Postgres’ v7 UUIDs are made monotonic, and why that’s a great feature.
Brandur Leach
I'm Brandur. This site is where I publish words and photos. The section updated most often is atoms , short multimedia particles reminiscent of a Twitter feed. I update my now page monthly according to what I'm working on and thinking about. I publish a newsletter as often as I can.
- Popular posts
- 39
- Total points
- 9,025
- HN comments
- 4,286
- Rank
- #95 personal
Visit brandur.org → RSS feedOn Hacker News May 2017 – Aug 2026
Software Engineering 27Databases & Data 20Tech Industry & Business 7Systems & Performance 6Career & Management 4Web & Frontend 3
2
Does anyone run Postgres without PgBouncer?
Almost every notable managed Postgres provider bundles a connection pooler, giving us a strong hint that connection management is a product problem rather than a user problem.
3
Feature Casualties of Large Databases
Databases shed important RDMS features as they get big. Examining why this tends to be the case, and some ideas for preventing it.
4
Actix Web: Optimization Amongst Optimizations
It’s already been a great reading day for retrospectives on the last ten years / predictions for the next. Here’s to hoping that everyone had a good break (or at least a few days off), set or didn’t set resolutions, and is refreshed and ready for what comes next.
5
Transactionally Staged Job Drains in Postgres
Building a robust background worker system that leverages transactional isolation to never work a job too early, and transactional durability to never let one drop.
6
Partitioning in Postgres, 2022 Edition
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.