| What caught my eye is the
update count can be up to 10K. That means if autovacuum is not keeping
up with this table, bloat may be increasing at a high pace leading to
more page I/O which causes degraded performance. If the table has
become bloated, you need to do a blocking VACUUM FULL on it or a
non-blocking VACUUM using pg_repack. Then tune autovacuum so that it
can keep up with the updates to this table or add manual vacuum analyze
on this table at certain times via a cron job. Manual vacuums
(user-initiated) will not be bumped as with autovacuums that can be
bumped due to user priority. Regards, Michael Vitale
|
