Re: Proposal for background vacuum full/cluster - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: Proposal for background vacuum full/cluster
Date
Msg-id d49r6r$2gai$1@news.hub.org
Whole thread Raw
In response to Proposal for background vacuum full/cluster  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Proposal for background vacuum full/cluster
List pgsql-hackers
> > 2) Is it possible to write a where clause that can efficiently hit only
> > the tuples in the end of the table?  If there is a way, then I could
> > test the idea without writing any code at all.
>
> Not sure, but you could try using the ctid column.
>

An alternative is to do a bulky ordered insert. Build an index on the table.
And write a where clause which just visit the big-value part of the table.

Regards,
Qingqing




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords
Next
From: Neil Conway
Date:
Subject: slides on the optimizer