Re: selects with large offset really slow

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selects with large offset really slow
Date: 2003-02-10 21:17:35
Message-ID: 20030210211735.17213.qmail@web40710.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


how?
Jean-Luc Lachance <jllachan(at)nsd(dot)ca> wrote:Why don't you use a temp table with a serial field and use is instead of
offset?

---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gregbcc 2003-02-10 21:34:57 GnuPG / PGP signed MD5 checksums for PostgreSQL 7.3.2, 7.3.1, 7.3, and 7.2.3
Previous Message Sean Chittenden 2003-02-10 20:57:42 Re: PostgreSQL x Oracle