Karen Hill wrote: > I have 8.2 Beta 1 (Win32) on my home pc and offset was faster than > fetching relative to the last key as measured by explain analyze. This > was on a table with about 1,000 rows. For such a small table the difference is probably irrelevant. Try with several million rows. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support