From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Sergey Tsukinovsky <Sergey.Tsukinovsky@cryptologic.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres: 100% CPU utilization
Date: Mon, 23 Apr 2007 11:09:05 -0500
Message-ID: <1177344544.7266.5.camel@state.g2switchworks.com> (raw)
In-Reply-To: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
References: <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
On Thu, 2007-04-19 at 14:29, Sergey Tsukinovsky wrote:
> Hi,
>
>
>
> I’m currently dealing with performance issues of postgres and looking
> for some advice.
>
>
>
> Platform
>
> Postgres: 7.0.2
>
> OS: FreeBSD4.4
>
> DB: size - about 50M, most frequently updated tables are of an average
> size of 1000-2000 rows and there are not many of them, about 15 in
> total
SNIP
> I know that 7.0.2 is an old version and therefore ran the same test on
> 7.3.18 – the performance behavior was similar.
So, are you running this on an Intel 486DX2-50 with a Seagate ST-4096
with an ISA based RLL encoding controller, or are you using the more
advanced AMD 586 CPU running at 90MHz with an Adaptec ARC2090 PCI based
SCSI card?
And do you have 32 or 64 Megs of memory in that machine?
Cause honestly, that's the kinda hardware I was running 7.0.2 on, so you
might as well get retro in your hardware department while you're at it.
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
Subject: Re: postgres: 100% CPU utilization
In-Reply-To: <1177344544.7266.5.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