Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY, LIMIT and indexes - Mailing list pgsql-performance

From Michael Paquier
Subject Re: ORDER BY, LIMIT and indexes
Date
Msg-id CAB7nPqRi=9EUa3PEOoaUggh8MHpHBSEjrghGFjdpH=NQKfEBFQ@mail.gmail.com
Whole thread Raw
In response to Re: ORDER BY, LIMIT and indexes  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: ORDER BY, LIMIT and indexes
List pgsql-performance
Tree view



On Tue, Aug 6, 2013 at 8:25 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
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?
--
Michael

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: ORDER BY, LIMIT and indexes
Next
From: Josh Berkus
Date:
Subject: Re: ORDER BY, LIMIT and indexes