Michael Aboagye

Michael is PostgreSQL consultant at Vettabase. He is specialised in PostgreSQL performance, security and automation.

Tuning PostgreSQL Auto-vacuum

Before we look at how to tune PostgreSQL auto-vacuum, let's take a brief look at the importance of vacuuming in PostgreSQL. Why Autovacuum is necessary In PostgreSQL, rows that are deleted or modified are not completely removed. Rather they are marked as dead tuples....

read more