Search Postgresql Archives
Re: Slow query: select * order by XXX desc offset 10 limit 10
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: Alexander Farber <
alexander.farber@xxxxxxxxx
>
Subject
: Re: Slow query: select * order by XXX desc offset 10 limit 10
From
: David Johnston <
polobo@xxxxxxxxx
>
Date
: Thu, 13 Oct 2011 10:08:27 -0400
Cc
: pgsql-general <
pgsql-general@xxxxxxxxxxxxxx
>
In-reply-to
: <
CAADeyWiyKocEVYW-A8X2XQ9SZs6NsUrnDej2CPsOath5rQnGwA@mail.gmail.com
>
On Oct 13, 2011, at 9:41, Alexander Farber <
alexander.farber@xxxxxxxxx
> wrote:
Does anybody please have an idea,
how to speed up my select statements?
Create one or more indexes.
David J.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Slow query: select * order by XXX desc offset 10 limit 10
From:
Alexander Farber
Prev by Date:
Slow query: select * order by XXX desc offset 10 limit 10
Next by Date:
Re: Slow query: select * order by XXX desc offset 10 limit 10
Previous by thread:
Slow query: select * order by XXX desc offset 10 limit 10
Next by thread:
Re: Slow query: select * order by XXX desc offset 10 limit 10
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
