Buy Percona ServicesBuy Now!

Tuning Autovacuum in PostgreSQL and Autovacuum Internals

and  | August 10, 2018 |  Posted In: Insight for DBAs, Performance Tuning, PostgreSQL

Tuning Autovacuum in PostgreSQL

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a […]

Read More

Basic Understanding of Bloat and VACUUM in PostgreSQL

 | August 6, 2018 |  Posted In: Insight for DBAs, PostgreSQL

VACUUM and Bloat PostgreSQL

Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an […]

Read More