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=q8hror8GJsUYbNqmfVcvVBgzOkR21lmD+GzqzcNKPDuGvQgpMGak8q47aVzIhGkCRM
	nNtJkzffN6FB0Tc1rMiqDMAxz72Ceju5EOe9PeTKbh84vSSUo/HOiXHggnDub/Q4+sh8
	0H2GFteOxr6lQBj0G7zS4j26IuTZM6i6XBGC0=
MIME-Version: 1.0
In-Reply-To: <z2x2f4958ff1004140630n121d4083oa79bb870c336bb7c@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
	<4BBF4FDD.3090008@2ndquadrant.com>
	<l2gb42b73151004090930r8942742fhe96e3c8fe4920916@mail.gmail.com>
	<r2ydcc563d11004090944vdee233a7w4dbf3ea99217005c@mail.gmail.com>
	<z2m4ff8a7a31004101154t3722b22bq618dea9782f237a8@mail.gmail.com>
	<t2n4ff8a7a31004140621l596f44e0u22a63c8bfa92e974@mail.gmail.com>
	<z2x2f4958ff1004140630n121d4083oa79bb870c336bb7c@mail.gmail.com>
Date: Wed, 14 Apr 2010 21:02:01 +0200
Message-ID: <q2y4ff8a7a31004141202w483f1973uc536f09dcc2775c4@mail.gmail.com>
Subject: Re: PostgreSQL with Zabbix - problem of newbe
From: Krzysztof Kardas <krzychk2@gmail.com>
To: =?ISO-8859-2?Q?Grzegorz_Ja=B6kiewicz?= <gryzman@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-2
Content-Transfer-Encoding: quoted-printable

W dniu 14 kwietnia 2010 15:30 u=BFytkownik Grzegorz Ja=B6kiewicz
<gryzman@gmail.com> napisa=B3:
> That really sounds like hardware issue. The I/O causes the system to free=
ze
> basically.
> Happens sometimes on cheaper hardware.
>

Probably You have right because this is HS21 Blade Server. And as You
know blades are cheap and good. Why blades are good - because they are
cheap (quoting IBM salesman). I know this hardware is not made for
databases but for now I do not have any other server. Firmware on this
current server is very old and it should be upgraded and there are
many other things to do. VMWare machines (currently I have ESX 3.5,
vSphere 4 is based od 64bit RedHat5 system and is much faster that 3.5
but migration process is not even planned) has still to low
performance for database solutions (of course in using vmdk, not RAW
device mapping or Virtual WWN solution for accessing LUN-s).

As more I am reading than more I see that the file system is wrong
partitioned. For example - all logs and database files are on the same
volume, and that is not right.
Kevin Grittner also mentioned about write back function on the
controller. LSI controllers for blades has that function as far as I
know. I have to check it if that option is turned on.

As I mentioned - I am not familiar with databases so I have made some
mistakes but I am very happy for the effects how fast now Zabbix
works, and how easy PostgreSQL reclaims space. I think it was a good
decision and maybe I will try to interest some people in my company in
PostgreSQL instate of Oracle XE.

Once more time - many thanks to all :)

--=20
Greetings
Krzysztof Kardas