Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4E8139FB321 for ; Tue, 6 Feb 2007 06:21:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 51188-10 for ; Tue, 6 Feb 2007 06:21:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id 7E72D9FB31A for ; Tue, 6 Feb 2007 06:21:43 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so121678nfb for ; Tue, 06 Feb 2007 02:21:42 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=l2H8z0FTNphGsskneqCoKowmaQwiVXdOYp1nKsiRATJjruLesp6VgHVOGncgpAwIe6Kdws1GvjlIveavOJ/Vh2hNo/5mLqUYjUxv5N3xDEswUDy0Y1R4bIhmGgw9OgnRK3s5Ji/GvDrqUG5g2jA8r9tTBX09c4pOx6fsM1TqOXY= Received: by 10.82.169.4 with SMTP id r4mr1833971bue.1170757301673; Tue, 06 Feb 2007 02:21:41 -0800 (PST) Received: by 10.82.191.6 with HTTP; Tue, 6 Feb 2007 02:21:41 -0800 (PST) Message-ID: <7be3f35d0702060221o46599dc3ua8a6ac6802b94fe0@mail.gmail.com> Date: Tue, 6 Feb 2007 11:21:41 +0100 From: "Harald Armin Massa" To: "Mischa Sandberg" Subject: Re: Tuning Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2352_7165067.1170757301400" References: <76C73999206F3145A2E3046A5C32A103F02EA1@kibmail.kib.local> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/60 X-Sequence-Number: 23114 ------=_Part_2352_7165067.1170757301400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Tuners, allways be aware that results on Windows may be totally different! My main customer is running PostgreSQL 8.1 on MINIMUM shared buffers max_connections =3D 100 # shared_buffers =3D 200 # min 16 or max_connections*2, 8KB each I changed it to this value from the very low default 20000, and the system is responding better; especially after fixing the available memory setting within the planner. ... frustrating part is, I could not replicate this behavious with pg_bench :( Harald --=20 GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstra=DFe 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords. ------=_Part_2352_7165067.1170757301400 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Tuners,

allways be aware that results on Windows may be totally diff= erent!

My main customer is running PostgreSQL 8.1 on MINIMUM shared = buffers

max_connections =3D 100       = #
shared_buffers =3D 200         &n= bsp;  # min 16 or max_connections*2, 8KB each

I changed it to this value from the very low default 20000, and the= system is responding better; especially after fixing the available memory = setting within the planner.

... frustrating part is, I could not rep= licate this behavious with pg_bench :(

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstra=DFe 20= 2b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Pytho= n: the only language with more web frameworks than keywords. ------=_Part_2352_7165067.1170757301400--