pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedautovacuum not working?
4+ messages / 3 participants
[nested] [flat]
* autovacuum not working?
@ 2006-10-09 13:38 Medora Schauer <mschauer@fairfield.com>
0 siblings, 1 reply; 4+ messages in thread
From: Medora Schauer @ 2006-10-09 13:38 UTC (permalink / raw)
To: pgsql-performance
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.
Am I missing something? Should there be something in the log file to
indicate that autovacuum has run?
I'm attaching my conf file.
Medora Schauer
Fairfield Industries
Attachments:
postgresql.conf (application/octet-stream, 13.8K) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum not working?
@ 2006-10-09 14:11 Bill Moran <wmoran@collaborativefusion.com>
parent: Medora Schauer <mschauer@fairfield.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bill Moran @ 2006-10-09 14:11 UTC (permalink / raw)
To: Medora Schauer <mschauer@fairfield.com>; +Cc: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum not working?
@ 2006-10-09 14:27 Medora Schauer <mschauer@fairfield.com>
0 siblings, 1 reply; 4+ messages in thread
From: Medora Schauer @ 2006-10-09 14:27 UTC (permalink / raw)
To: Bill Moran <wmoran@collaborativefusion.com>; +Cc: pgsql-performance
> From: Bill Moran [mailto:wmoran@collaborativefusion.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.
>
> From your attached config file:
>
> #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
> # vacuum
>
Yup, that was it.
Thanks.
Medora
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum not working?
@ 2006-10-09 21:26 Jim C. Nasby <jim@nasby.net>
parent: Medora Schauer <mschauer@fairfield.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jim C. Nasby @ 2006-10-09 21:26 UTC (permalink / raw)
To: Medora Schauer <mschauer@fairfield.com>; +Cc: Bill Moran <wmoran@collaborativefusion.com>; pgsql-performance
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 reltuples, but it won't update other
stats. That's what analyze does (autovacuum_analyze_threshold). By
default, that's set to 500; I'll typically drop it to 200 or so (keep in
mind that analyze is much cheaper than vacuum).
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-10-09 21:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-09 13:38 autovacuum not working? Medora Schauer <mschauer@fairfield.com>
2006-10-09 14:11 ` Bill Moran <wmoran@collaborativefusion.com>
2006-10-09 14:27 Re: autovacuum not working? Medora Schauer <mschauer@fairfield.com>
2006-10-09 21:26 ` Jim C. Nasby <jim@nasby.net>
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