by Pablo Svampa | May 7, 2024 | Insight for DBAs, PostgreSQL
Last week, we were assisting a client who needed to resolve an issue related to partitioned tables.Often, a table can include dozens or even hundreds of partitions. Unfortunately, some object-level parameters for tuning (like storage_parameter) cannot be modified from... by Pablo Svampa | Apr 2, 2024 | Insight for DBAs, PostgreSQL
One of the most frequent concerns we see in the Percona support team is: Why is my pg_wal growing? / pg_wal is filling up the filesystem / pg_wal does not release the space, and so on.In PostgreSQL, the pg_wal directory plays a crucial role in managing the Write-Ahead...