DatabasesPlanet PostgreSQL
Databases
pgsql_tweaks is a bundle of functions and views for PostgreSQL Changes In The pgsql_tweaks 1.0.4 Release pgsql_tweaks is a bundle of functions and views for PostgreSQL The source code is available on Codeberg. The extension is also…
A skewed partition key can route 80% of your writes to one partition. Learn how to diagnose PostgreSQL partition hot spots and fix them at the schema level.
Logical replication has been an integral part of Postgres since version 10 released in 2017. It's a very convenient system for synchronizing one or more tables from one running Postgres cluster to another, and the community has embraced it…
PostgreSQL 18 finally made extensions truly relocatable by adding `extension_control_path` to match the long-existing `dynamic_library_path`.