Avoid scanning on tape

From: Manolo _ <mac_man2005(at)hotmail(dot)it>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Avoid scanning on tape
Date: 2008-02-11 18:40:32
Message-ID: BAY112-W30F9087C41172EB00E66F7E62A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 specific tape.
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 the other 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-02-11 19:27:57 Re: Avoid scanning on tape
Previous Message Christopher Browne 2008-02-11 17:56:29 Re: pg_dump additional options for performance