Re: postgres: 100% CPU utilization

From: Tom Lane
Subject: Re: postgres: 100% CPU utilization
Date: ,
Msg-id: 14185.1177302961@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: postgres: 100% CPU utilization  ("Sergey Tsukinovsky")
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, )

"Sergey Tsukinovsky" <> writes:
> I'm currently dealing with performance issues of postgres and looking
> for some advice.

> Postgres: 7.0.2

Stop right there.  You have *no* business asking for help on an
installation you have not updated in more than six years.

            regards, tom lane


pgsql-performance by date:

From: Heikki Linnakangas
Date:
Subject: Re: TPC-H Scaling Factors X PostgreSQL Cluster Command
From: "henk de wit"
Date:
Subject: Re: Redundant sub query triggers slow nested loop left join