Re: VACUUM/ANALYZE counting of in-doubt tuples - Mailing list pgsql-hackers

From Tom Lane
Subject Re: VACUUM/ANALYZE counting of in-doubt tuples
Date
Msg-id 15089.1195669979@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM/ANALYZE counting of in-doubt tuples  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: VACUUM/ANALYZE counting of in-doubt tuples
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Tom Lane wrote:
>> Should we attempt to adjust VACUUM's accounting as well, or leave it
>> for 8.4?  For that matter, should adjusting ANALYZE be left for 8.4?
>> Thoughts?

> Has this issue been a real problem?  If so, probably we should consider
> adjusting ANALYZE for 8.3 per your proposal.

I'm not sure.  Upthread, two or three people said they thought they'd
seen autovac launching vacuums against tables during bulk inserts.
However, that could only happen if there were already a reason to launch
an auto-analyze (which could misreport dead tuples and thus trigger a
subsequent auto-vacuum), and in typical bulk load situations I don't see
why that would be very likely to happen.

I'm fine with leaving the whole issue for 8.4.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres 8.3 archive_command
Next
From: Magnus Hagander
Date:
Subject: Re: pgsql: New versions of mingw have gettimeofday(), so add an autoconf