Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL with Zabbix - problem of newbe

From: Krzysztof Kardas <krzychk2(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: 2010-04-14 19:02:01
Message-ID: q2y4ff8a7a31004141202w483f1973uc536f09dcc2775c4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
W dniu 14 kwietnia 2010 15:30 użytkownik Grzegorz Jaśkiewicz
<gryzman(at)gmail(dot)com> napisał:
> That really sounds like hardware issue. The I/O causes the system to freeze
> 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 :)

-- 
Greetings
Krzysztof Kardas

In response to

pgsql-performance by date

Next:From: Dave CrookeDate: 2010-04-14 20:49:16
Subject: JDBC question for PG 8.3.9
Previous:From: Kevin GrittnerDate: 2010-04-14 14:31:33
Subject: Re: significant slow down with various LIMIT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group