"Greg Sabino Mullane" <greg(at)turnstep(dot)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