Channel Corporation shares how they split their all-purpose Amazon DynamoDB User table into role-specific tables, moving Badge data into a dedicated UserBadge table to stop transaction-conflict throttling and GSI back…
Amazon Relational Database Service (RDS) for PostgreSQL now supports the latest minor versions 18.6, 17.11, 16.15, 15.19, and 14.24. We recommend that you upgrade to the latest minor versions to address Common…
Starting today, Amazon EC2 M8i and M8i-flex instances are now available in Canada West (Calgary) region. These instances are powered by custom Intel Xeon 6 processors, available only on AWS, delivering the highest…
Just in time for the PostgreSQL 19 betas, I'm excited to announce release 1.2 of pg_statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. This…
Sam Lambert is back after 4 years and he does not hold back! We cover $5 PlanetScale Postgres, the Neki "do-over" of Vitess, agents shipping schema changes through deploy requests, rolling back a 500TB table in seconds,…
Well, truth be told these are not all that new (couple of months), but I finally have gotten around to research it. So, let's see what's what. For starters I need some test data. Luckily, I have explain.depesz.com DB……
It’s hard to say anything new about query optimization. On the one hand, each new Postgres release includes multiple query planner improvements, and it feels like there is something for any problem that can possibly…
Deploying a database is the easy day. The interesting days are the ones after: it needs more memory, more read capacity, or a version bump, and you would rather not take an outage for any of them. With the CYBERTEC PG…
On 19 August 2026, the Postgres Meetup for All - Group met online, organized by Elizabeth Christensen. James Nelson and Philip Johnston delivered a talk Hyderabad PGDays 2026 took place from 20-21 August 2026…
Beyond observability: building the synchronized, simulatable model AI agents need before they touch production The digital twin you are building may depend on one you have not built yet. Most digital-twin programs begin…
And now, we put on our waders and venture into the swamp that is all of the PostgreSQL logging GUCs. PostgreSQL 8.3 is the release in which the server started doing its own housekeeping in earnest: autovacuum on by…
PostgreSQL 19 introduces a new SQL command, WAIT FOR, that lets a session block until WAL has reached a specific position. This gives us read-your-writes consistency on asynchronous replicas without paying the…
Scenario-Tree Testing in PostgreSQL: Every Authored Branch, Shared History, Before COMMIT# Express the branching scenarios of your business logic as a directory tree; walk it with savepoints so each branch inherits its…