Tom,
Neither database has and per-table autovacuum settings.
However, since this is a production database, I had to try something,
and set vacuum_cost_limit up to 1000. The issue with vacuuming one page
at a time went away, or at least I have not seen it repeat in the last
16 hours.
--
Josh Berkus wrote:
Tom,
Neither database has and per-table autovacuum settings.
However, since this is a production database, I had to try
something, and set vacuum_cost_limit up to 1000. The issue with
vacuuming one page at a time went away, or at least I have not seen
it repeat in the
How many autovac workers are there?
Max_workers is set to 3. However, I've never seen more than one active
at a time.
--
-- Josh Berkus
PostgreSQL Experts Inc.
Josh Berkus wrote:
Basically, vacuuming of a table which normally takes about 20 minutes
interactively with vacuum_cost_delay set to 20 had not completed after
14 hours. When I trussed it, I saw activity which indicated to me that
autovacuum was doing a pollsys, presumably for cost_limit,
Alvaro Herrera alvhe...@commandprompt.com writes:
We don't call pollsys anywhere. Something in Solaris must be doing it
under the hood.
pg_usleep calls select(), and some googling indicates that select() is
implemented as pollsys() on recent Solaris versions. So Josh's
assumption that those
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
We don't call pollsys anywhere. Something in Solaris must be doing it
under the hood.
pg_usleep calls select(), and some googling indicates that select() is
implemented as pollsys() on recent Solaris versions. So Josh's
Josh Berkus j...@agliodbs.com writes:
But it shouldn't
be sleeping after each page with normal cost_delay parameters, should it?
Right, that's why I find this puzzling. If the problem was easier to
reproduce it would be easier to analyze.
The behavior would be explained if VacuumCostLimit
Josh, are you sure that both servers are identical in terms of both
GUC-related and per-table autovacuum settings?
I should check per-table. GUC, yes, because the company has source
management for config files.
--
-- Josh Berkus