Postgres Pro
Downloads
Home   >   mailing lists

Re: Any ideas how can I speed up this query? - Mailing list pgsql-performance

From 林士博
Subject Re: Any ideas how can I speed up this query?
Date
Msg-id CACudzGj9ZgsL7+R4f9tux7_+Uz8QQjtySnuAhXRio8LJ12Cuzw@mail.gmail.com
Whole thread Raw
In response to Any ideas how can I speed up this query?  (Priyank Tiwari <priyankgt@gmail.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: Any ideas how can I speed up this query?
Next
From: "Graeme B. Bell"
Date:
Subject: autofreeze/vacuuming - avoiding the random performance hit