Jobin Augustine builds a queue:
In many real production databases, we often see some tables receiving high-frequency updates (millions per day) and autovacuum running repeatedly (hundreds of times per day). Additionally, those tables can sometimes become heavily bloated. The end effect is poor performance, poor concurrency, and an unmanageable database.
In case we are using methods pg_gather for diagnosis, such anomalies are easy to spot by clicking on the table header to sort.
Read on to learn more about the PgQue extension and how it works.