DatabasesPlanet PostgreSQL
Databases
One of our client’s PostgreSQL 16.8 production databases started logging what looked like a memory error: ERROR: invalid memory alloc request size The error immediately pointed toward two likely suspects: Memory exhaustion Memory…
After more than 20 years working with PostgreSQL, I keep seeing the same problems surface at the worst possible times - bloat that sneaks up on you, replication slots quietly holding back WAL, transaction ID wraparound that nobody caught…
pgsql_tweaks is a bundle of functions and views for PostgreSQL Changes In The pgsql_tweaks 1.0.5 Release pgsql_tweaks is a bundle of functions and views for PostgreSQL The source code is available on Codeberg. The extension is also…
Postgres 18 introduced temporal keys (WITHOUT OVERLAPS, PERIOD).Postgres 19 expands (UPDATE/DELETE ... FOR PORTION OF) temporal capabilities further.