DatabasesPlanet PostgreSQL
Databases
PostgreSQL 19 is an admin-and-monitoring release with 212 items: worker-managed AIO, smarter planner joins, faster diagnostics, and a C11 requirement.
Random UUIDv4 keys cause B-tree page splits and bloat indexes up to 35%. See how UUIDv7's time-ordered IDs keep Postgres ingestion fast at scale.
PGX is stepping in to maintain pgBackRest as pgxbackup, ensuring critical fixes and PostgreSQL compatibility for the industry-standard backup tool.
There's been a kind of persistent myth regarding Postgres since I first started using it seriously over 20 years ago: "Postgres doesn't support user variables." This hasn't really been true since version 8.0 way back in 2005. Part of this…