From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Sergey Tsukinovsky <Sergey.Tsukinovsky@cryptologic.com>
Cc: Ron <rjpeace@earthlink.net>
Cc: Mario Weilguni <mweilguni@sime.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres: 100% CPU utilization
Date: Thu, 26 Apr 2007 17:50:27 -0500
Message-ID: <1177627827.15085.87.camel@state.g2switchworks.com> (raw)
In-Reply-To: <2C20E65455FC964690D89F8C4A2E9B1D03ABA7F9@STRAIGHTFLUSH.cryptologic.com>
References: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
<200704231053.38952.mweilguni@sime.com>
<E1Hg07i-0004wn-Sr@elasmtp-dupuy.atl.sa.earthlink.net>
<2C20E65455FC964690D89F8C4A2E9B1D03ABA7F9@STRAIGHTFLUSH.cryptologic.com>
On Tue, 2007-04-24 at 10:30, Sergey Tsukinovsky wrote:
> Thanks for this reply, Ron.
> This is almost what I was looking for.
>
> While the upgrade to the latest version is out of the question (which
> unfortunately for me became the subject of this discussion) still, I was
> looking for the ways to improve the performance of the 7.0.2 version.
>
> Extensive use of vacuum was almost obvious, though I was hoping to get
> some more tips from postrges gurus (or dinosaurs, if you want).
>
> Anyways, the 8.2.4 was not performing so well without auto-vacuum. It
> ramped up to 50% of CPU usage in 2 hours under the load.
> With the auto-vacuum ON I've got what I really need and thus I know what
> to do next.
Could you give us a better picture of how you were testing 8.2.4? My
guess is that you were doing something that seemed right to you, but was
working against yourself, like constant vacuum fulls and getting index
bloat, or something else.
Why were you trying to not use autovacuum, btw? I've found it to be
quite capable, with only a few situations (high speed queueing) where I
needed to manually schedule vacuums. And I've never seen a situation
since about 7.4 where regular full vacuums were required.
> Just for the record - the hardware that was used for the test has the
> following parameters:
> AMD Opteron 2GHZ
> 2GB RAM
> LSI Logic SCSI
Nice hardware. I'd really like to hear the logic behind your statement
that upgrading to 8.1 or 8.2 is out of the question.
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: smarlowe@g2switchworks.com, Sergey.Tsukinovsky@cryptologic.com, rjpeace@earthlink.net, mweilguni@sime.com
Subject: Re: postgres: 100% CPU utilization
In-Reply-To: <1177627827.15085.87.camel@state.g2switchworks.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