On Sat, 15 Mar 2008, mark <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
