Re: Slow query: select * order by XXX desc offset 10 limit 10

From: David Johnston <polobo(at)yahoo(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10
Date: 2011-10-13 14:08:27
Message-ID: 6F417497-5814-4A4E-84E1-CF7B67B44C26@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Oct 13, 2011, at 9:41, Alexander Farber <alexander(dot)farber(at)gmail(dot)com> wrote:

>
> Does anybody please have an idea,
> how to speed up my select statements?
>

Create one or more indexes.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2011-10-13 14:09:44 Re: Slow query: select * order by XXX desc offset 10 limit 10
Previous Message Alexander Farber 2011-10-13 13:41:56 Slow query: select * order by XXX desc offset 10 limit 10