Re: Speed with offset clause

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Speed with offset clause
Date: 2005-06-24 18:54:55
Message-ID: 9e4684ce05062411545fdfe5fc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6/24/05, Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be> wrote:
> So, when I want the last page, which is: 600k / 25 = page 24000 - 1 =
> 23999, I issue the offset of 23999 * 25

improving this is hard, but not impossible.
if you have right index created, try to reverse the order and fetch
first adverts, and then resort it (just the 25 adverts) in correct
order.
it will be faster.

depesz

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-06-24 19:16:02 Re: max_connections / shared_buffers / effective_cache_size
Previous Message Puddle 2005-06-24 18:54:31 max_connections / shared_buffers / effective_cache_size questions