Skip site navigation (1) Skip section navigation (2)

Re: Poor query performance

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alex <alex(at)liivid(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor query performance
Date: 2009-07-20 05:39:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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
vacuum full.

In response to


pgsql-performance by date

Next:From: Peter EisentrautDate: 2009-07-20 06:02:34
Subject: Re: Fastest char datatype
Previous:From: Robert JamesDate: 2009-07-20 01:46:53
Subject: Fastest char datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group