Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum, analyze, and setting reltuples of pg_class - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum, analyze, and setting reltuples of pg_class
Date
Msg-id 13642.1165856910@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum, analyze, and setting reltuples of pg_class  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Vacuum, analyze, and setting reltuples of pg_class  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: Vacuum, analyze, and setting reltuples of pg_class  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
Tree view 
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Short version: is it optimal for vacuum to always populate reltuples
> with live rows + dead rows?

If we didn't do that, it would tend to encourage the use of seqscans on
tables with lots of dead rows, which is probably a bad thing.

> Is there any way to encourage those dead rows to go away,

Close your open transactions.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Vacuum, analyze, and setting reltuples of pg_class
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Vacuum, analyze, and setting reltuples of pg_class