From: Josh Berkus <josh@agliodbs.com>
To: Ken Egervari <ken@upfactor.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help with tuning this query (with explain analyze finally)
Date: Thu, 3 Mar 2005 09:35:14 -0800
Message-ID: <200503030935.14537.josh@agliodbs.com> (raw)
In-Reply-To: <004601c51fbe$828bbb50$6a01a8c0@KEN>
References: <001001c51ef4$3849eeb0$6a01a8c0@KEN>
<200503022152.13211.josh@agliodbs.com>
<004601c51fbe$828bbb50$6a01a8c0@KEN>
Ken,
Well, I'm a bit stumped on troubleshooting the actual query since Windows'
poor time resolution makes it impossible to trust the actual execution times.
Obviously this is something we need to look into for the Win32 port for
8.1 ..
> shared_buffers = 1000
This may be slowing up that merge join. Try resetting it to 6000. I'm not
sure what system settings you might have to do on Windows to get it to
support higher shared buffers; see the docs.
> #work_mem = 1024
Up this to 4096 for testing purposes; your production value will vary
depending on several factors; see link below.
> #effective_cache_size = 1000
Increase this to the actual amount of RAM you have available, about 750MB (you
do the math)
> #random_page_cost = 4
Leave this for now.
See www.powerpostgresql.com/PerfList for more information.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, ken@upfactor.com
Subject: Re: Help with tuning this query (with explain analyze finally)
In-Reply-To: <200503030935.14537.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox