From: Amitabh Kant <amitabhkant@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
Date: Wed, 3 Feb 2010 20:42:24 +0530
Message-ID: <84b68b3d1002030712j6fab33b8xe1d0f1071d207bcb@mail.gmail.com> (raw)
In-Reply-To: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com>
References: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com>
Forgot to add that I am using Postgres 8.4.2 from the default ports of
FreeBSD.
With regards
Amitabh Kant
On Wed, Feb 3, 2010 at 8:40 PM, Amitabh Kant <amitabhkant@gmail.com> wrote:
> Hello
>
> I have a server dedicated for Postgres with the following specs:
>
> RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @
> 2.33GHz
> OS: FreeBSD 8.0
>
> It runs multiple (approx 10) databases ranging from 500MB to over 24 GB in
> size. All of them are of the same structure, and almost all of them have
> very heavy read and writes.
>
> pgtune (http://pgfoundry.org/projects/pgtune/) suggests the settings to be
> changed as :
>
> maintenance_work_mem = 960MB # pg_generate_conf wizard 2010-02-03
> checkpoint_completion_target = 0.9 # pg_generate_conf wizard 2010-02-03
> effective_cache_size = 11GB # pg_generate_conf wizard 2010-02-03
> work_mem = 160MB # pg_generate_conf wizard 2010-02-03
> wal_buffers = 8MB # pg_generate_conf wizard 2010-02-03
> checkpoint_segments = 16 # pg_generate_conf wizard 2010-02-03
> shared_buffers = 3840MB # pg_generate_conf wizard 2010-02-03
> max_connections = 100 # pg_generate_conf wizard 2010-02-03
>
>
> While this gives me the changes for postgresql.conf, I am not sure of of
> the chnages that I need to make in FreeBSD to support such large memory
> allocations. The last time I tried, Postgres refused to start and I had to
> fall back to the default settings.
>
> I would appreciate if somebody could point out the sysctl/loader.conf
> settings that I need to have in FreeBSD.
>
> With regards
>
> Amitabh Kant
>
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: amitabhkant@gmail.com
Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
In-Reply-To: <84b68b3d1002030712j6fab33b8xe1d0f1071d207bcb@mail.gmail.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