Re: [GENERAL] autovacuum = on ignored

2006-08-17 Thread Alvaro Herrera
Vivek Khera wrote: > > On Aug 17, 2006, at 12:43 PM, Matthew T. O'Connor wrote: > > >Do you have row level stats enabled? > > is block level stats not sufficient for autovacuum? > > i'm seeing the same: "show all" tells me autovacuum is off, but it is > for sure turned on in the postgresql.co

Re: [GENERAL] autovacuum = on ignored

2006-08-17 Thread Vivek Khera
On Aug 17, 2006, at 12:43 PM, Matthew T. O'Connor wrote: Do you have row level stats enabled? is block level stats not sufficient for autovacuum? i'm seeing the same: "show all" tells me autovacuum is off, but it is for sure turned on in the postgresql.conf file and block level stats are

Re: [GENERAL] autovacuum = on ignored

2006-08-17 Thread Matthew T. O'Connor
Gene wrote: For some reason when I restart postgresql the autovacuum = on is ignored and when I do a show all it is showed as being off. It did not always do this until recently. What is the best way to diagnose what maybe happening? Are there other config files which may prevent it from being

[GENERAL] autovacuum = on ignored

2006-08-17 Thread Gene
For some reason when I restart postgresql the autovacuum = on is ignored and when I do a show all it is showed as being off. It did not always do this until recently. What is the best way to diagnose what maybe happening? Are there other config files which may prevent it from being run? Thanks -- E