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.
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
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
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