From: Bill Moran <wmoran@collaborativefusion.com>
To: Medora Schauer <mschauer@fairfield.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum not working?
Date: Mon, 9 Oct 2006 10:11:28 -0400
Message-ID: <20061009101128.7664a933.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <1CA058827877644DAB54FB930FFA3B05D89F15@lincoln.FAIRIND.FAIRFIELD.COM>
References: <1CA058827877644DAB54FB930FFA3B05D89F15@lincoln.FAIRIND.FAIRFIELD.COM>
In response to "Medora Schauer" <mschauer@fairfield.com>:
> 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 for a table to be updated after
> autovacuum ran. This doesn't seem to be the case. I added 511 records
> to a previously empty table and waited over an hour. Tuples for the
> table (as per pgaccess) was 0. After I did a manual vacuum analyze it
> went to 511.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, mschauer@fairfield.com
Subject: Re: autovacuum not working?
In-Reply-To: <20061009101128.7664a933.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox