Re: Vacuuming - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuuming
Date
Msg-id 23763.1178606370@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuuming  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Responses Re: Vacuuming
List pgsql-general
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> On 5/8/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I forgot to mention that any other operation that examines every table
>> row will fix all the hint bits as well.  In particular a CREATE INDEX
>> would do that ---

> I might be missing something, but I think CREATE INDEX work on
> SnapshotAny and hence may not actually examine any table row ?

SnapshotAny is a no-op, but HeapTupleSatisfiesVacuum isn't.

            regards, tom lane

pgsql-general by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: Vacuuming
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Vacuuming