Re: pg_autovacuum - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_autovacuum
Date
Msg-id 12631.1136991824@sss.pgh.pa.us
Whole thread Raw
In response to pg_autovacuum  (Eran L <eranlz@gmail.com>)
List pgsql-admin
Eran L <eranlz@gmail.com> writes:
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:

> stats_row_level = true

> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:

> [2006-01-11 12:11:07 IST] ERROR:   GUC variable stats_row_level must be enabled.
> [2006-01-11 12:11:07 IST]                 Please fix the problems and try again.

Does "SHOW stats_row_level" agree that it's not on?  If so, maybe you
forgot stats_start_collector.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Replication solutions high volume db
Next
From: Jaime Casanova
Date:
Subject: Re: pg_autovacuum