On Sat, 15 Mar 2008, mark <markkicks@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general