[PERFORM] autovacuum not working?

2006-10-09 Thread Medora Schauer
Ive recently moved to 8.1 and find that autovacuum doesnt seem to be working, at least not the way I expected it to. I need the tuple count for a table to be updated so indexes will be used when appropriate. I was expecting the tuples count for a table to be updated after autovacuum ran.

Re: [PERFORM] autovacuum not working?

2006-10-09 Thread Bill Moran
In response to Medora Schauer [EMAIL PROTECTED]: I've recently moved to 8.1 and find that autovacuum doesn't seem to be working, at least not the way I expected it to. I need the tuple count for a table to be updated so indexes will be used when appropriate. I was expecting the tuples count

Re: [PERFORM] autovacuum not working?

2006-10-09 Thread Medora Schauer
From: Bill Moran [mailto:[EMAIL PROTECTED] In response to Medora Schauer [EMAIL PROTECTED]: I've recently moved to 8.1 and find that autovacuum doesn't seem to be working, at least not the way I expected it to. I need the tuple count for a table to be updated so indexes will be used

Re: [PERFORM] autovacuum not working?

2006-10-09 Thread Jim C. Nasby
On Mon, Oct 09, 2006 at 09:27:30AM -0500, Medora Schauer wrote: From your attached config file: #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before # vacuum Yup, that was it. Actually, not quite. Vacuum will update relpages and