Re: really lazy vacuums? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: really lazy vacuums?
Date
Msg-id 4781.1300147209@sss.pgh.pa.us
Whole thread Raw
In response to Re: really lazy vacuums?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: really lazy vacuums?
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Mar 14, 2011 at 4:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Um, if there are *no* dead tuples then we don't look at the indexes
>> anyway ...

> But you do still have to scan the heap twice.

Seems like that should be fixable ... is the second pass actually
going to do anything?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: Fwd: index corruption in PG 8.3.13
Next
From: Josh Berkus
Date:
Subject: Re: Better estimates of index correlation