block and row are always configured on - they are my friend :) thanks On Wednesday 21 June 2006 13:44, Csaba Nagy wrote: > On Wed, 2006-06-21 at 18:39, jody brownell wrote: > > that is exactly what I am seeing, one process, no change, always in idle while the others are constantly > > changing their state. > > > > looks like someone opened a tx then is blocking on a queue lock or something. dang. > > Don't forget to check the statistics collector settings (see below), if > that is not correct then autovacuum is indeed not working correctly... I > should have put that on the beginning of the mail so you won't overlook > it ;-) > > > > > > > Oh, just occured to me... in order to use autovacuum you also need to > > > enable the statistics collector on row level: > > > > > > stats_start_collector = on > > > stats_row_level = on > > > > > > See also: > > > http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM > > > > > > This was not mentioned in the settings in your original post, so I guess > > > you didn't touch that, and I think they are disabled by default. > > > > > > If this is disabled, you should enable it and "pg_ctl reload ....", that > > > should fix the problem. > > > > > > Cheers, > > > Csaba. > > > >
