Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C0AA0B5DBDC for ; Thu, 4 Aug 2011 17:27:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 47072-07 for ; Thu, 4 Aug 2011 20:27:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm30-vm1.bullet.mail.ne1.yahoo.com (nm30-vm1.bullet.mail.ne1.yahoo.com [98.138.90.46]) by mail.postgresql.org (Postfix) with SMTP id 4E027B5DBD9 for ; Thu, 4 Aug 2011 17:27:14 -0300 (ADT) Received: from [98.138.90.54] by nm30.bullet.mail.ne1.yahoo.com with NNFMP; 04 Aug 2011 20:27:14 -0000 Received: from [98.138.89.170] by tm7.bullet.mail.ne1.yahoo.com with NNFMP; 04 Aug 2011 20:27:13 -0000 Received: from [127.0.0.1] by omp1026.mail.ne1.yahoo.com with NNFMP; 04 Aug 2011 20:27:13 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 979406.76620.bm@omp1026.mail.ne1.yahoo.com Received: (qmail 82011 invoked by uid 60001); 4 Aug 2011 20:27:13 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1312489633; bh=iCEMrFK+YwApNtMDKFv95aZyM1u9qFQnArK9tX9hVH8=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=qCOg5wFyCXQL68MniGE+WzxAnf1i/Z2ElIcYqCDMRw6GfxtiJZcy6zib2guyEvy3dnAZq04FMQqMxYeCVfdO6p5DVAoR3CjuxCfdAliaqWTl/+4U7uDKjMdlBwiktEDUc/Rnvc7N3SlhXeUcUJz2WecwmGXF+Nj3Qw0N0rvtBwY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type; b=w0QfhbFwWgrPwo3N+RBgdzeR8X+RrSdM5ONcQEqi3IYhprVw7bKaNhX0RoHQaGDwF/2+VkpNOoqtuJOpe51E4hSWkCUmLHAbu+1GBid2OvWTQtKEDFB26QMTtDsYMGLNiCc179629PgtqcoMqcBJI/CldAuCu9BgX6E09v3M+J8=; X-YMail-OSG: N047BNgVM1mSjwHWebSJyzrA4FCQeG78tfWF8T9pfgidojF .vgeNmkL9pb13OpeeGuwnCkXAFq8u_c6B1eIUfxbP43TtCmWepune369zQ18 OC8YCITjFHJHWaS0O301N7H5c5MA0tbufSBTPyPHpZZKQ03.Ac2vkFhIwiVJ wD6n4TG9AXprPlA.cbtvQ._NEYiIB5pBjRSk56nQa6FBYukAVdKx8ekC50YV 7s_IjxZh4rNuY2s99fx8e7wfna2pwi.MHIFFF7tpQrzDDlE3M7.L9rSbPytJ IEhbhjMfjTGWGSlkOkmG0hS4waQC5cZQ6JvgYBT7qxEglo4fwW5sjoRlYWhr oejTYLYTd84rB8f4UqWaJIwR5f8xZR5ex0RpFNyYLYzg_DZrOOx.3QGzK0Sp EMc9OlXuIKUcqJzEnnELzi8bveM9Zed6oLHuuZA26lND.vcleZwZXmD.AfVt quA-- Received: from [66.201.45.122] by web31912.mail.mud.yahoo.com via HTTP; Thu, 04 Aug 2011 13:27:13 PDT X-Mailer: YahooMailClassic/14.0.4 YahooMailWebService/0.8.113.313619 Message-ID: <1312489633.71838.YahooMailClassic@web31912.mail.mud.yahoo.com> Date: Thu, 4 Aug 2011 13:27:13 -0700 (PDT) From: Claire Chang Subject: Postgres 8.4 memory related parameters To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1077114736-1312489633=:71838" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.604 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.716, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201108/63 X-Sequence-Number: 44510 --0-1077114736-1312489633=:71838 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable hi,=A0We recently bought a 4 8core 128G memory database server and I am set= ting it up to replace our old 4 4cores 128G memory database server as a mas= ter. The memory related settings that we use on the old machine seem a bit = wrong according to the experts on IRC: max_connections =3D 600shared_buffers =3D 32GBeffective_cache_size =3D 64GB= work_mem =3D 5MBmaintenance_work_mem =3D 1GB=A0wal_buffers =3D=A064kB we are using ubuntu 10/etc/sysctl.confkernel.shmmax=3D35433480192kernel.shm= all=3D8650752 Can anyone suggest better values? thanks,Claire --0-1077114736-1312489633=:71838 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
hi,
We recen= tly bought a 4 8core 128G memory database server and I am setting it up to = replace our old 4 4cores 128G memory database server as a master. The memor= y related settings that we use on the old machine seem a bit wrong accordin= g to the experts on IRC:

max_connections =3D 600
shared_buffers =3D 32GB
effective_cache_si= ze =3D 64GB
work_mem =3D 5MB
maintenance_work_mem =3D 1GB 
wal_buffers =3D 64kB=

<= /font>
we are using ubuntu 10
/etc/sysctl.conf
kernel.shmmax=3D35433480192=
kernel.shmall=3D8650752

Can anyone sugg= est better values?

thanks,
Claire
<= /font>
--0-1077114736-1312489633=:71838--