Subject: Re: postgres: 100% CPU utilization
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Sergey Tsukinovsky <Sergey.Tsukinovsky@cryptologic.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: 
 <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
References: 
 <2C20E65455FC964690D89F8C4A2E9B1D03A669CD@STRAIGHTFLUSH.cryptologic.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Message-Id: <1177344544.7266.5.camel@state.g2switchworks.com>
Mime-Version: 1.0
Date: Mon, 23 Apr 2007 11:09:05 -0500

On Thu, 2007-04-19 at 14:29, Sergey Tsukinovsky wrote:
> Hi,
>=20
> =20
>=20
> I=E2=80=99m currently dealing with performance issues of postgres and loo=
king
> for some advice.
>=20
> =20
>=20
> Platform
>=20
> Postgres: 7.0.2
>=20
> OS: FreeBSD4.4
>=20
> 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 =E2=80=93 the performance behavior was similar.=20

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.