Re: Speed with offset clause - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: Speed with offset clause
Date
Msg-id 9e4684ce05062411545fdfe5fc@mail.gmail.com
Whole thread Raw
In response to Speed with offset clause  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
On 6/24/05, Yves Vindevogel <yves.vindevogel@implements.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

pgsql-performance by date:

Previous
From: Puddle
Date:
Subject: max_connections / shared_buffers / effective_cache_size questions
Next
From: John A Meinel
Date:
Subject: Re: max_connections / shared_buffers / effective_cache_size