Re: Proposal for background vacuum full/cluster

All the issues brought up are why I'm not in favor of trying to do this
outside of the backend.

On Fri, Apr 22, 2005 at 11:29:27AM +0800, Qingqing Zhou wrote:
> 
> > > 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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"