Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
Quick Links
Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites
Re: selects with large offset really slow
From:
Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To:
John Smith <john_smith_45678(at)yahoo(dot)com>
Cc:
pgsql-general(at)postgresql(dot)org
Subject:
Re: selects with large offset really slow
Date:
2003-02-10 18:21:03
Message-ID:
3E47ED8F.9649A4B0@nsd.ca
Views:
Raw Message
|
Whole Thread
|
Download mbox
|
Resend email
Thread:
2003-02-07 05:01:14 from John Smith <john_smith_45678(at)yahoo(dot)com>
2003-02-07 12:02:47 from Richard Huxton <dev(at)archonet(dot)com>
2003-02-07 20:54:21 from John Smith <john_smith_45678(at)yahoo(dot)com>
2003-02-10 18:21:03 from Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
2003-02-10 21:17:35 from John Smith <john_smith_45678(at)yahoo(dot)com>
2003-02-11 16:50:02 from Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
2003-02-07 22:19:02 from John Smith <john_smith_45678(at)yahoo(dot)com>
2003-02-07 18:55:47 from greg(at)turnstep(dot)com
2003-02-08 00:20:53 from Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
2003-02-08 01:07:43 from John Smith <john_smith_45678(at)yahoo(dot)com>
Lists:
pgsql-general
Why don't you use a temp table with a serial field and use is instead of
offset?
In response to
Re: selects with large offset really slow
at 2003-02-07 20:54:21 from John Smith
Responses
Re: selects with large offset really slow
at 2003-02-10 21:17:35 from John Smith
Browse pgsql-general by date
From
Date
Subject
Next Message
Holger Klawitter
2003-02-10 18:29:50
renaming table leaves constraint behind [7.3.2]
Previous Message
Lamar Owen
2003-02-10 18:12:55
Re: upgrade from 7.3.1 to 7.3.2