From: Krzysztof Kardas <krzychk2@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: Wed, 14 Apr 2010 15:21:41 +0200
Message-ID: <t2n4ff8a7a31004140621l596f44e0u22a63c8bfa92e974@mail.gmail.com> (raw)
In-Reply-To: <z2m4ff8a7a31004101154t3722b22bq618dea9782f237a8@mail.gmail.com>
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
<4BBF4FDD.3090008@2ndquadrant.com>
<l2gb42b73151004090930r8942742fhe96e3c8fe4920916@mail.gmail.com>
<r2ydcc563d11004090944vdee233a7w4dbf3ea99217005c@mail.gmail.com>
<z2m4ff8a7a31004101154t3722b22bq618dea9782f237a8@mail.gmail.com>
<cut>
Hi all.
Well I have used all Your recomendations but I still have no luck with
performance tunning. The machine has a moments thas was utilized in
100%. The problem was I/O on disks. CPU's were busy on system
interrupts.
I have started again to look of I/O performance tunning and I have changed a
synchronous_commit = off
Ofcourse with risk that if there will be a power failure I will lose
some data. But this is acceptable.
This caused a monumental performance jump. From a machine that is
utilized on 100%, machine is now sleeping and doing nothing. I have
executed some sqls on huge tables like history and all has executed
like lightning. Comparing to MySQL, PostgreSQL in this configuration
is about 30 - 40% faster in serving data. Housekeeper is about 2 to 3
times faster!!!!
Many thanks to all helpers and all PostgreSQL team.
--
Greeting
Krzysztof Kardas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: krzychk2@gmail.com, scott.marlowe@gmail.com
Subject: Re: PostgreSQL with Zabbix - problem of newbe
In-Reply-To: <t2n4ff8a7a31004140621l596f44e0u22a63c8bfa92e974@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox