cpu utilization question - Mailing list pgsql-novice

From Wright, George
Subject cpu utilization question
Date
Msg-id 51548D6D5BEB57468163194A8C1A0E980161A541@MAGPTCPEXC02.na.mag-ias.net
Whole thread Raw
List pgsql-novice

We’re running Suse 10.2, PG 8.1.5, PHP 5.2.

 

We’re seeing high CPU percentages for multiple instances of postmaster: 15 – 30% for each instance. I realize a new instance is spawned for each connection that is opened and we have lots of clients sending very small text messages to our app for which we record a row per message.

 

We also have other periodic jobs that get kicked off but don’t use near the cpu percentage that postmaster seems to.

 

Is there a way to minimize postmaster’s cpu usage or is there some way to share that process between requests?

 

Thx.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Specify tables to be backed up
Next
From: "Wright, George"
Date:
Subject: Re: cpu utilization question