On Jan 25, 2007, at 10:33 AM, Ray Stell wrote:
> On Thu, Jan 25, 2007 at 08:04:49AM -0800, Joshua D. Drake wrote:
>> It really depends on the system. Most of our systems run anywhere
>> 10-25ms. I find that any more than that, Vacuum takes too long.
> How do you measure the impact of setting it to 12 as opposed to 15?
If you've got a tool that will report disk utilization as a
percentage it's very easy; I'll decrease the setting until I'm at
about 90% utilization with the system's normal workload (leaving some
room for spikes, etc). Sometimes I'll also tune the costs if reads
vs. writes are a concern.
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
pgsql-performance by date
|Next:||From: Carlos Moreno||Date: 2007-01-27 02:18:42|
|Subject: Seqscan/Indexscan still a known issue?|
|Previous:||From: Anton Rommerskirchen||Date: 2007-01-26 15:17:20|
|Subject: Re: Tuning|
pgsql-hackers by date
|Next:||From: Magnus Hagander||Date: 2007-01-26 21:10:20|
|Subject: Re: VC2005 build and pthreads|
|Previous:||From: Martijn van Oosterhout||Date: 2007-01-26 21:01:23|
|Subject: Re: Recursive query syntax ambiguity|