DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=KltljrgVG+DiQyJeV8riNEd3SFQt8XEB7H8ZfiYXm8klwMUAjSpoQNkG9zH1XROAun
	VSg8SZycu4kRoWvstRFIR+96kcHQoxTf0Cd6uUaoE/vCPjPn7EYHnsn9VtGzaf0Vv6YA
	WDVr0ruFqPFM7Jp83D5bk4y5jSzAy7h3SdKHE=
MIME-Version: 1.0
In-Reply-To: <r2ydcc563d11004090944vdee233a7w4dbf3ea99217005c@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
	<4BBF4FDD.3090008@2ndquadrant.com>
	<l2gb42b73151004090930r8942742fhe96e3c8fe4920916@mail.gmail.com>
	<r2ydcc563d11004090944vdee233a7w4dbf3ea99217005c@mail.gmail.com>
Date: Sat, 10 Apr 2010 20:54:04 +0200
Message-ID: <z2m4ff8a7a31004101154t3722b22bq618dea9782f237a8@mail.gmail.com>
Subject: Re: PostgreSQL with Zabbix - problem of newbe
From: Krzysztof Kardas <krzychk2@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>, Greg Smith <greg@2ndquadrant.com>,
	pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/4/9 Scott Marlowe <scott.marlowe@gmail.com>:
> On Fri, Apr 9, 2010 at 10:30 AM, Merlin Moncure <mmoncure@gmail.com> wrot=
e:
>> On Fri, Apr 9, 2010 at 12:03 PM, Greg Smith <greg@2ndquadrant.com> wrote=
:
>>> The main problem with this configuration is that work_mem is set to an
>>> unsafe value--1.6GB. =A0With potentially 400 connections and about 2GB =
of RAM
>>> free after starting the server, work_mem=3D'4MB' is as large as you can=
 safely
>>> set this.
>>
>> if you need more work_mem for this or that and also need to serve a
>> lot of connections, you can always set it locally (1.6GB is still too
>> high though -- maybe 64mb if you need to do a big sort or something
>> like that).
>>
>> Another path to take is to install pgbouncer, which at 400 connections
>> is worth considering -- but only if your client stack doesn't use
>> certain features that require a private database session. =A0zabbix will
>> _probably_ work because it is db portable software (still should check
>> however).
>
> Also remember you can set it by user or by db, depending on your
> needs. =A0I had a server that had a reporting db and an app db. =A0The ap=
p
> db was set to 1 or 2 Meg work_mem, and the reporting db that had only
> one or two threads ever run at once was set to 128Meg. =A0Worked
> perfectly for what we needed.
>

Thanks for all Your advices. I will set up new parameters on Monday
morning and see how it perform.

Greetings for all PostgreSQL Team

--=20
Krzysztof Kardas