Re: pg_autovacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eran L <eranlz(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_autovacuum
Date: 2006-01-11 15:03:44
Message-ID: 12631.1136991824@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Eran L <eranlz(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2006-01-11 15:08:51 Re: pg_autovacuum
Previous Message Praveen Kumar (TUV) 2006-01-11 11:53:03 how can we use outer join in Postures