Re: postgres: 100% CPU utilization

From: Vivek Khera
Subject: Re: postgres: 100% CPU utilization
Date: ,
Msg-id: A5A57AB2-8863-4296-A7F1-32FDA3711F9C@khera.org
(view: Whole thread, Raw)
In response to: Re: postgres: 100% CPU utilization  (Scott Marlowe)
Responses: Re: postgres: 100% CPU utilization  (Scott Marlowe)
List: pgsql-performance

Tree view

postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
 Re: postgres: 100% CPU utilization  (Tom Lane, )
 Re: postgres: 100% CPU utilization  (Andreas Tille, )
 Re: postgres: 100% CPU utilization  (Mario Weilguni, )
  Re: postgres: 100% CPU utilization  (Ron, )
   Re: postgres: 100% CPU utilization  ("Sergey Tsukinovsky", )
    Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Mark Kirkwood, )
 Re: postgres: 100% CPU utilization  (Scott Marlowe, )
  Re: postgres: 100% CPU utilization  (Vivek Khera, )
   Re: postgres: 100% CPU utilization  (Scott Marlowe, )
    Re: postgres: 100% CPU utilization  (Greg Smith, )
  Re: postgres: 100% CPU utilization  (Mark Kirkwood, )

On Apr 23, 2007, at 12:09 PM, Scott Marlowe wrote:

> 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.

I think you're being too conservative... I recall that those specs
for me correspond to running Pg 6.5 as the latest release...  talk
about performance and corruption issues... :-)  He's probably got at
least a Pentium II.


Attachment

pgsql-performance by date:

From: Mark Kirkwood
Date:
Subject: Re: postgres: 100% CPU utilization
From: Greg Smith
Date:
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command