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

Re: postgres: 100% CPU utilization

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Sergey Tsukinovsky <Sergey(dot)Tsukinovsky(at)cryptologic(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres: 100% CPU utilization
Date: 2007-04-23 16:09:05
Message-ID: 1177344544.7266.5.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

Responses

pgsql-performance by date

Next:From: Arkadiusz RajDate: 2007-04-23 17:20:29
Subject: index usage
Previous:From: Nelson KotowskiDate: 2007-04-23 15:52:36
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command

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