On Sat, 15 Mar 2008, mark <markkicks@gmail.com> writes:
> select * from users where session_key is not Null order by id offset OFFSET limit 300
>
> i want to go through the whole table... it gets really slow like
> greater than 5 minutes when the OFFSET is over 500,000..
Did you try your chance with CURSORs? (See manual page for DECLARE.)
Regards.