Postgres Pro
Downloads
Home   >   mailing lists

Re: best way to fetch next/prev record based on index - Mailing list pgsql-performance

From Tom Lane
Subject Re: best way to fetch next/prev record based on index
Date
Msg-id 29487.1090942399@sss.pgh.pa.us
Whole thread Raw
In response to best way to fetch next/prev record based on index  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: best way to fetch next/prev record based on index
List pgsql-performance
Tree view 
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Plus, your where clause does not guarantee results.

No, but in combination with the ORDER BY it does.  Please note also
that the offset would *always* be one, so your gripe about it not
scaling seems misguided to me.

            regards, tom lane

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Automagic tuning
Next
From: Markus Schaber
Date:
Subject: Correction of best way to fetch next/prev record based on index