Re: stats collector process high CPU utilization - Mailing list pgsql-performance

minshall@intellicon.biz writes:
> While exploring this problem, I've noticed that one of the frequent insert
> processes creates a few temporary tables to do post-processing.  Is it
> possible that the stats collector is getting bloated with stats from these
> short-lived temporary tables?  During periods of high activity it could be
> creating temporary tables as often as two per second.

Hmmm ... that's an interesting point, but offhand I don't see why it'd
cause more of a problem in 8.2 than 8.1.  Alvaro, any thoughts?

            regards, tom lane