From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matthew T. O'Connor <matthew@zeut.net>
Cc: Otto Blomqvist <o.blomqvist@secomintl.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_autovacuum not having enough suction ?
Date: Fri, 25 Mar 2005 14:55:27 -0500
Message-ID: <11991.1111780527@sss.pgh.pa.us> (raw)
In-Reply-To: <42446A66.6010504@zeut.net>
References: <d1v0a7$iau$1@news.hub.org>
<42430FA0.9080204@zeut.net>
<002b01c530c5$ad5a1620$e602a8c0@blomqvist>
<42435408.30303@zeut.net>
<00f201c53168$96903480$e602a8c0@blomqvist>
<42446A66.6010504@zeut.net>
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> hmm.... the value in reltuples should be accurate after a vacuum (or
> vacuum analyze) if it's not it's a vacuum bug or something is going on
> that isn't understood. If you or pg_autovacuum are running plain
> analyze commands, that could explain the invalid reltules numbers.
> Was reltuples = 113082 correct right after the vacuum?
Another thing to check is whether the reltuples (and relpages!) that
autovacuum is reporting are the same as what's actually in the pg_class
row for the relation. I'm wondering if this could be a similar issue
to the old autovac bug where it wasn't reading the value correctly.
If they are the same then it seems like it must be a backend issue.
One thing that is possibly relevant here is that in 8.0 a plain VACUUM
doesn't set reltuples to the exactly correct number, but to an
interpolated value that reflects our estimate of the "steady state"
average between vacuums. I wonder if that code is wrong, or if it's
operating as designed but is confusing autovac.
Can autovac be told to run the vacuums in VERBOSE mode? It would be
useful to compare what VERBOSE has to say to the changes in
reltuples/relpages.
regards, tom lane
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: tgl@sss.pgh.pa.us, matthew@zeut.net, o.blomqvist@secomintl.com
Subject: Re: pg_autovacuum not having enough suction ?
In-Reply-To: <11991.1111780527@sss.pgh.pa.us>
* 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