> > but when i use offset in the same statement
> > select * from detail2 where id>125000 order by info1 limit 10 offset
> > 10000
> > the plan changes
> > Limit (cost=36.47..36.47 rows=1 width=52)
> > -> Sort (cost=36.47..36.47 rows=333 width=52)
> > -> Seq Scan on detail2 (cost=0.00..22.50 rows=333 width=52)
> > and it takes almost 50 seconds to complete (42.890 sec)
> > Can anyone explain why offset doesn't use the index available?
> >
>
> How many rows does detail2 have? What does explain say for the query and
> how long does it take if you set enable_seqscan=off before it?
>
It doesn't change the explain when i try
set enable_seqscan=off;
select * from detail2 where id>125000 order by info1 limit 10 offset 10000;
And it still takes 42+ seconds
the table has 250000 records.
Thanks in advance.
Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro