Re: Any ideas how can I speed up this query?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Any ideas how can I speed up this query?
From
: 林士博 <
lin@xxxxxxxxxxxx
>
Date
: Tue, 28 Jul 2015 17:57:51 +0900
Cc
:
pgsql-performance@xxxxxxxxxxxxxx
In-reply-to
: <CADbPz3G+rUaf3gDm5QQ97=38E2HNd619ZJ=9v61uY24p3P0xUA@mail.gmail.com>
1 GB of ram is quite small.
I think it is worth to try creating an index on a combination of columns(lat, lng).
So that Bitmap Heap Scan would be omitted.
References
:
Any ideas how can I speed up this query?
From:
Priyank Tiwari
Prev by Date:
Re: Any ideas how can I speed up this query?
Next by Date:
autofreeze/vacuuming - avoiding the random performance hit
Previous by thread:
Re: Any ideas how can I speed up this query?
Next by thread:
autofreeze/vacuuming - avoiding the random performance hit
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
