On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <ivoras@freebsd.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?