Avoid scanning on tape

Поиск
Список
Период
Сортировка
От Manolo _
Тема Avoid scanning on tape
Дата
Msg-id BAY112-W30F9087C41172EB00E66F7E62A0@phx.gbl
обсуждение исходный текст
Ответы Re: Avoid scanning on tape
Список pgsql-hackers
Hi.

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.

Of course I could store that address of first tuple as soon as I start the creation of the corresponding new run. On
theother hand I could store the address of that last tuple when I terminate the creation of that run. 

The problem is that Postgres writes tuples in various buffers before really writing blocks of tuples on disk.

Is there an efficient way to access to those tuples avoiding scanning a specific run from the last tuple till the first
one?

Thanks for your attention.

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

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

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