Stanislav Raskin wrote:
> Now, if I increase OFFSET slowly, it works all the same way, until OFFSET
> reaches the value of 750. Then, the planner refuses to use an index scan and
> does a plain seq scan+sort, which makes the query about 10-20 times slower:
You may want to try setting enable_seqsc
which is not the case, because serial ids
are not necessarily continuous (i.e. if some data sets were deleted).
-Ursprüngliche Nachricht-
Von: Scott Marlowe [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 31. August 2008 17:26
An: Stanislav Raskin
Cc: pgsql-general@postgresql.org
Betreff: R
On Sun, Aug 31, 2008 at 7:14 AM, Stanislav Raskin <[EMAIL PROTECTED]> wrote:
> Hello everybody,
>
> Now, if I increase OFFSET slowly, it works all the same way, until OFFSET
> reaches the value of 750. Then, the planner refuses to use an index scan and
> does a plain seq scan+sort, which makes the
