On Thu, Jul 9, 2009 at 3:34 PM, Alex<alex(at)liivid(dot)com> wrote:
> Below is a query that takes 16 seconds on the first run. I am having
> generally poor performance for queries in uncached areas of the data
> and often mediocre (500ms-2s+) performance generallly, although
> sometimes it's very fast. All the queries are pretty similar and use
> the indexes this way.
> I've been trying to tune this thing with little luck. There are about
> 1.5M records. It's using the index properly. Settings are:
> work_mem=20MB, shared_buffers=128MB, effective_cache_size=1024MB.
> I have run ANALYZE and VACUUM FULL recently.
Note that vacuum full can bloat indexes, good idea to reindex after a
In response to
pgsql-performance by date
|Next:||From: Peter Eisentraut||Date: 2009-07-20 06:02:34|
|Subject: Re: Fastest char datatype|
|Previous:||From: Robert James||Date: 2009-07-20 01:46:53|
|Subject: Fastest char datatype|