On Tue, Aug 6, 2013 at 8:25 AM, Claudio Freire <[email protected]>wrote:
> On Mon, Aug 5, 2013 at 8:04 PM, Ivan Voras <[email protected]> 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
