Re: ORDER BY, LIMIT and indexes

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ORDER BY, LIMIT and indexes
Date: 2013-08-05 23:25:58
Message-ID: CAGTBQpaUJz7jWpOdrOLiVteWvbYe8O4n37dy9k4hc2Dx1r5Ceg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2013-08-06 00:20:18 Re: ORDER BY, LIMIT and indexes
Previous Message Ivan Voras 2013-08-05 23:04:10 ORDER BY, LIMIT and indexes