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
it will be faster.
In response to
pgsql-performance by date
|Next:||From: John A Meinel||Date: 2005-06-24 19:16:02|
|Subject: Re: max_connections / shared_buffers / effective_cache_size|
|Previous:||From: Puddle||Date: 2005-06-24 18:54:31|
|Subject: max_connections / shared_buffers / effective_cache_size questions|