Postgres Pro
Downloads
Home   >   mailing lists

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

From Claudio Freire
Subject Re: ORDER BY, LIMIT and indexes
Date
Msg-id CAGTBQpaUJz7jWpOdrOLiVteWvbYe8O4n37dy9k4hc2Dx1r5Ceg@mail.gmail.com
Whole thread Raw
In response to ORDER BY, LIMIT and indexes  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: ORDER BY, LIMIT and indexes
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: ORDER BY, LIMIT and indexes
Next
From: Michael Paquier
Date:
Subject: Re: ORDER BY, LIMIT and indexes