Re: stats collector process high CPU utilization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Minshall <minshall(at)intellicon(dot)biz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: stats collector process high CPU utilization
Date: 2007-02-08 22:07:56
Message-ID: 20601.1170972476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Benjamin Minshall <minshall(at)intellicon(dot)biz> writes:
> Seems the problem may be related to a huge global/pgstat.stat file.
> Under 8.1.5 it was about 1 MB; now it's 90 MB in 8.2.3.

Yoi. We didn't do anything that would bloat that file if it were
storing the same information as before. What I'm betting is that it's
storing info on a whole lot more tables than before. Did you decide
to start running autovacuum when you updated to 8.2? How many tables
are visible in the pg_stats views?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Benjamin Minshall 2007-02-08 22:29:23 Re: stats collector process high CPU utilization
Previous Message Benjamin Minshall 2007-02-08 21:55:25 Re: stats collector process high CPU utilization