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(at)postgresql(dot)org)
>

--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)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?"