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

Re: Help how to tune-up my Database

From: Bricklen <bricklen-rem(at)yahoo(dot)comz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help how to tune-up my Database
Date: 2004-05-07 16:47:09
Message-ID: h4Pmc.5347$uN4.1032@clgrps12 (view raw or flat)
Thread:
Lists: pgsql-performance
scott.marlowe wrote:
> sort_mem might do with a small bump, especially if you're only handling a 
> few connections at a time.  Be careful, it's per sort, and measured in 
> megs, so it's easy for folks to set it too high and make their machine 
> start flushing too much kernel cache, which will slow down the other 
> backends that have to go to disk for data.
<snip>
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
(under "Memory"), it says that sort_mem is set in KB. Is this document 
wrong (or outdated)?

In response to

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-05-07 23:35:44
Subject: Re: [OFF-TOPIC] - Known maximum size of the
Previous:From: scott.marloweDate: 2004-05-07 16:00:03
Subject: Re: Help how to tune-up my Database

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