Re: Any ideas how can I speed up this query?

From: 林士博 <lin(at)repica(dot)co(dot)jp>
To: Priyank Tiwari <priyankgt(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Any ideas how can I speed up this query?
Date: 2015-07-28 08:57:51
Message-ID: CACudzGj9ZgsL7+R4f9tux7_+Uz8QQjtySnuAhXRio8LJ12Cuzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Graeme B. Bell 2015-07-28 15:39:41 autofreeze/vacuuming - avoiding the random performance hit
Previous Message Graeme B. Bell 2015-07-28 08:19:00 Re: Any ideas how can I speed up this query?