It's been about a month and a half, and I'm getting this VACUUM
again. This time, I'm wondering if there's any way to tell if
autovacuum is doing a database-wide vacuum for the sake of xid
wraparound or for some other reason. Is there some sort of entry that
gets put into the log, and if so,
[EMAIL PROTECTED] escribió:
It's been about a month and a half, and I'm getting this VACUUM
again. This time, I'm wondering if there's any way to tell if
autovacuum is doing a database-wide vacuum for the sake of xid
wraparound or for some other reason. Is there some sort of entry that
gets
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
I'm just wondering if autovacuum is ever supposed to vacuum the entire
database during one of its runs. As far as I remember, it's supposed
to vacuum one table at a time, based on the
autovacuum_vacuum_threshold, autovacuum_analyze_threshold, etc.
Hi,
I'm just wondering if autovacuum is ever supposed to vacuum the entire
database during one of its runs. As far as I remember, it's supposed
to vacuum one table at a time, based on the
autovacuum_vacuum_threshold, autovacuum_analyze_threshold, etc.
settings.
For some reason, autovacuum
