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

Re: Configuration Issue ?

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Mark Lonsdale <mark(dot)lonsdale(at)wysdm(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuration Issue ?
Date: 2006-10-26 19:08:38
Message-ID: 20061026190837.GC26892@nasby.net (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, Oct 25, 2006 at 05:31:29PM -0400, Mark Lonsdale wrote:
> Set my sort_mem to 8192

You really need to look at what your workload is before trying to tweak
sort_mem. With 8G of memory, sort_mem=400000 (~400MB) with only 10
active connections might be a good setting. It's usually better to get a
sort to fit into memory than spill to disk. Since you never mentioned
what kind of workload you have or how many active connections there are,
it's pretty much impossible to make a recommendation on that setting.
-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-10-26 19:17:29
Subject: Re: VACUUMs take twice as long across all nodes
Previous:From: Joshua D. DrakeDate: 2006-10-26 18:32:02
Subject: Re: OT: TCL vs Perl Re: commit so slow program looks frozen

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