From: | Manolo _ <mac_man2005(at)hotmail(dot)it> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Avoid scanning on tape |
Date: | 2008-02-11 19:42:18 |
Message-ID: | BAY112-W342BD02ACFEE0B4E94B188E62A0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2008-02-11 20:07:01 | Re: pg_dump additional options for performance |
Previous Message | Tom Lane | 2008-02-11 19:27:57 | Re: Avoid scanning on tape |