Message-ID: <4909D5FF.9070709@gmx.net>
Date: Thu, 30 Oct 2008 16:42:55 +0100
From: Ulrich <ulrich.mierendorff@gmx.net>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
To: Christiaan Willemsen <cwillemsen@technocon.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Configuring for maximum memory usage
References: <4909CF9C.80701@technocon.com>
In-Reply-To: <4909CF9C.80701@technocon.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,
you could set effective_cache_size to a high value (free memory on your 
server that is used for caching).
Christiaan Willemsen wrote:
> Hi there,
>
> I configured OpenSolaris on our OpenSolaris Machine. Specs:
>
> 2x Quad 2.6 Ghz Xeon
> 64 GB of memory
> 16x 15k5 SAS
>
> The filesystem is configured using ZFS, and I think I have found a 
> configuration that performs fairly well.
>
> I installed the standard PostgreSQL that came with the OpenSolaris 
> disk (8.3), and later added support for PostGIS. All fime.
> I also tried to tune postgresql.conf to maximize performance and also 
> memory usage.
>
> Since PostgreSQL is the only thing running on this machine, we want it 
> to take full advantage of the hardware. For the ZFS cache, we have 8 
> GB reserved. The rest can be used by postgres.
>
> The problem is getting it to use that much. At the moment, it only 
> uses almost 9 GB, so by far not enough. The problem is getting it to 
> use more... I hope you can help me with working config.
>
> Here are the parameters I set in the config file:
>
> shared_buffers = 8192MB
> work_mem = 128MB
> maintenance_work_mem = 2048MB
> max_fsm_pages = 204800
> max_fsm_relations = 2000
>
> Database is about 250 GB in size, so we really need to have as much 
> data as possible in memory.
>
> I hope you can help us tweak a few parameters to make sure all memory 
> will be used.
>
>
>
>