Re: selects with large offset really slow

John,

CREATE TEMP TABLE results (
ndx SERIAL,
{ plus all the fields you get from your query}
);

INSERT INTO results( {all your fields except ndx})
SELECT ...
;

then

select ... from results where dnx >= start limit 100;

JLL

John Smith wrote:

> how?
>
> Jean-Luc Lachance <jllachan(at)nsd(dot)ca> wrote:
>
> Why don't you use a temp table with a serial field and use is instead of
> offset?