Re: Avoid scanning on tape

Thanks for your reply.

I need to read all the run in order to move it to another tape. I suppose the only way to make it is reading the run tuple by tuple and writing them into the destination tape.

Regards, Manolo.

----------------------------------------
> To: mac_man2005(at)hotmail(dot)it
> CC: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Avoid scanning on tape
> Date: Mon, 11 Feb 2008 14:27:57 -0500
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> Manolo _ writes:
>> I would like to store the "address on tape" of the first and the last tuple for the run I'm currently creating on a specific tape.
>> I need it in order to access directly to those two tuples right after terminating the creation of that specific run.
>
> Why don't you just hold those two tuples in memory (ie, track the first
> and latest-so-far tuples of each run)?
>
> regards, tom lane

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/