Re: Avoid scanning on tape

Поиск
Список
Период
Сортировка
От Manolo _
Тема Re: Avoid scanning on tape
Дата
Msg-id BAY112-W342BD02ACFEE0B4E94B188E62A0@phx.gbl
обсуждение исходный текст
Ответ на Re: Avoid scanning on tape  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
tupleby tuple and writing them into the destination tape. 

Regards, Manolo.

----------------------------------------
> To: mac_man2005@hotmail.it
> CC: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Avoid scanning on tape
> Date: Mon, 11 Feb 2008 14:27:57 -0500
> From: tgl@sss.pgh.pa.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
specifictape. 
>> 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/

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Avoid scanning on tape
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: pg_dump additional options for performance