On Tue, Aug 6, 2013 at 8:25 AM, Claudio Freire <klaussfreire(at)gmail(dot)com>wrote:
> On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <ivoras(at)freebsd(dot)org> wrote:
> > SELECT * FROM table ORDER BY id DESC LIMIT 10 OFFSET 10
> >
> > SELECT * FROM table WHERE active ORDER BY id DESC LIMIT 10 OFFSET 10
>
> Did you try explain?
>
And did you run ANALYZE on your table to be sure that you generate correct
plans?
--
Michael