On 6/24/05, Yves Vindevogel <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend