Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: John A MeinelDate: 2005-06-24 19:16:02
Subject: Re: max_connections / shared_buffers / effective_cache_size
Previous:From: PuddleDate: 2005-06-24 18:54:31
Subject: max_connections / shared_buffers / effective_cache_size questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group