pg_autovacuum

pg_autovacuum

am 11.01.2006 11:11:29 von Eran L

Hi,

I must be missing some obvious and trivial thing, since I simply can
get pg_autovacuum to work.

Im working on FC4, postgresql 8.0.6.
In the "postgresql.conf" file, I've set:

stats_row_level =3D 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 ena=
bled.
[2006-01-11 12:11:07 IST] Please fix the problems and try a=
gain.

What more needs to be done ?

TIA,
Eran

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: pg_autovacuum

am 11.01.2006 16:03:44 von Tom Lane

Eran L 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: pg_autovacuum

am 11.01.2006 16:08:51 von Jaime Casanova

On 1/11/06, Eran L wrote:
> Hi,
>
> I must be missing some obvious and trivial thing, since I simply can
> get pg_autovacuum to work.
>
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
>
> stats_row_level =3D true
>
> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it sa=
ys:
>
> [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be e=
nabled.
> [2006-01-11 12:11:07 IST] Please fix the problems and try=
again.
>
> What more needs to be done ?
>
> TIA,
> Eran
>

i guess you remove the # symbol in front of that line

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster