Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query: select * order by XXX desc offset 10 limit 10 - Mailing list pgsql-general

From David Johnston
Subject Re: Slow query: select * order by XXX desc offset 10 limit 10
Date
Msg-id 6F417497-5814-4A4E-84E1-CF7B67B44C26@yahoo.com
Whole thread Raw
In response to Slow query: select * order by XXX desc offset 10 limit 10  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view
On Oct 13, 2011, at 9:41, Alexander Farber <alexander.farber@gmail.com> wrote:


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


Create one or more indexes.

David J.

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Slow query: select * order by XXX desc offset 10 limit 10
Next
From: Bill Moran
Date:
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10