DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:from:date:message-id:subject:to:content-type;
	b=az0jI91ZqUREHwN5dGqTZINfbxphDzGzFTexEvlWlRTq4zJjqlKA7Zs9trDfuRU4vm
	kcMNOzgXDBzbeQdhoeHoLQ4kqwNfon7/x8uI+0+WHZgUY9efFgfT79SWPQxIOD/2UCXP
	SNuINY9qlmfvsxiUeFFyvu4UBLIJkaXkbsN4M=
MIME-Version: 1.0
From: Amitabh Kant <amitabhkant@gmail.com>
Date: Wed, 3 Feb 2010 20:40:57 +0530
Message-ID: <84b68b3d1002030710x76c31adft58c56624409011fd@mail.gmail.com>
Subject: Optimizing Postgresql server and FreeBSD for heavy read and writes
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0021cc0233d2657894047eb3a7d8

--0021cc0233d2657894047eb3a7d8
Content-Type: text/plain; charset=ISO-8859-1

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

--0021cc0233d2657894047eb3a7d8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello <br><br>I have a server dedicated for Postgres with the following spe=
cs:<br><br>RAM 16GB, 146GB SAS (15K) x 4 -=A0 RAID 10 with BBU, Dual Xeon=
=A0 E5345=A0 @ 2.33GHz=A0 <br>OS: FreeBSD 8.0<br><br>It runs multiple (appr=
ox 10) databases ranging from 500MB to=20
over 24 GB in size. All of them are of the same structure, and almost=20
all of them have very heavy read and writes. <br>
<br>pgtune (<a href=3D"http://pgfoundry.org/projects/pgtune/">http://pgfoun=
dry.org/projects/pgtune/</a>) suggests the settings to be changed as :<br><=
br>maintenance_work_mem =3D 960MB # pg_generate_conf wizard 2010-02-03<br>

checkpoint_completion_target =3D 0.9 # pg_generate_conf wizard 2010-02-03<b=
r>effective_cache_size =3D 11GB # pg_generate_conf wizard 2010-02-03<br>wor=
k_mem =3D 160MB # pg_generate_conf wizard 2010-02-03<br>wal_buffers =3D 8MB=
 # pg_generate_conf wizard 2010-02-03<br>

checkpoint_segments =3D 16 # pg_generate_conf wizard 2010-02-03<br>shared_b=
uffers =3D 3840MB # pg_generate_conf wizard 2010-02-03<br>max_connections =
=3D 100 # pg_generate_conf wizard 2010-02-03<br><br><br>While this gives me=
 the changes for postgresql.conf, I am not sure of=A0 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 defa=
ult settings.<br>

<br>I would appreciate if somebody could point out the sysctl/loader.conf s=
ettings that I need to have in FreeBSD.<br><br>With regards<br><br>Amitabh =
Kant<br>

--0021cc0233d2657894047eb3a7d8--