On Tue, Aug 6, 2013 at 8:25 AM, Claudio Freire <klaussfre...@gmail.com>wrote:
> On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <ivo...@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? -- Michael
