pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Benjamin Minshall <minshall@intellicon.biz>
To: pgsql-performance@postgresql.org
Subject: stats collector process high CPU utilization
Date: Thu, 08 Feb 2007 11:48:01 -0500
Message-ID: <45CB5441.1040707@intellicon.biz> (raw)

Greetings,

Since upgrading to 8.2.3 yesterday, the stats collector process has had 
very high CPU utilization; it is consuming roughly 80-90% of one CPU. 
The server seems a lot more sluggish than it was before.  Is this normal 
operation for 8.2 or something I should look into correcting?

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = false

-- 
Benjamin Minshall <minshall@intellicon.biz>
Senior Developer -- Intellicon, Inc.

Attachments:

  smime.p7s (application/x-pkcs7-signature, 5.1K) download

view thread (27+ messages)  latest in thread

Message-ID: <45CB5441.1040707@intellicon.biz>
Permalink:  ../45CB5441.1040707@intellicon.biz/
Also on:    postgresql.org/message-id/45CB5441.1040707@intellicon.biz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: minshall@intellicon.biz
  Subject: Re: stats collector process high CPU utilization
  In-Reply-To: <45CB5441.1040707@intellicon.biz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox