Royce Ausburn <[email protected]> writes:
> Since sending this first email I've up'd the autovacuum log level and I've
> noticed that the same tables seem to be auto vacuum'd over and over againâ¦
> Some of the tables are a bit surprising in that they're updated
> semi-regularly, but not enough (I'd think) to warrant an autovacuum every few
> minutes⦠Is this unusual?
Well, that proves autovacuum isn't getting blocked anyway. At this
point I suspect that Marti has fingered the correct issue: you likely
need to increase the FSM settings. You should try running a manual
VACUUM VERBOSE and see if it suggests that more FSM space is needed
(there'll be some FSM stats at the end of the verbose printout).
> Perhaps unrelated: I've done some digging around and happened across a
> nightly task doing:
> select pg_stat_reset()
> on each of the databases in the clusterâ¦. I've no idea why we're doing that
> (and our usual sysadmin / DBA has resigned, so I doubt I'll ever know).
> There must have been a reason at the time, but I wonder if this might be
> interfering with things?
Hmm, it's not helping any. Anything that needs vacuuming, but less
often than once a day, would get missed due to the stats getting
forgotten.
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
