Re: selects with large offset really slow - Mailing list pgsql-general

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@nsd.ca> wrote:
>
>      Why don't you use a temp table with a serial field and use is instead of
>      offset?