Re: stats collector process high CPU utilization

От: Alvaro Herrera
Тема: Re: stats collector process high CPU utilization
Дата: ,
Msg-id: 20070209142459.GB4253@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: stats collector process high CPU utilization  (Tom Lane)
Ответы: Re: stats collector process high CPU utilization  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

stats collector process high CPU utilization  (Benjamin Minshall, )
 Re: stats collector process high CPU utilization  (Tom Lane, )
  Re: stats collector process high CPU utilization  (Benjamin Minshall, )
   Re: stats collector process high CPU utilization  (Tom Lane, )
    Re: stats collector process high CPU utilization  (Benjamin Minshall, )
     Re: stats collector process high CPU utilization  (Tom Lane, )
      Re: stats collector process high CPU utilization  (Benjamin Minshall, )
       Re: stats collector process high CPU utilization  (Tom Lane, )
        Re: stats collector process high CPU utilization  (Benjamin Minshall, )
         Re: stats collector process high CPU utilization  (Tom Lane, )
          Re: stats collector process high CPU utilization  (, )
           Re: stats collector process high CPU utilization  (Tom Lane, )
            Re: stats collector process high CPU utilization  (Alvaro Herrera, )
             Re: stats collector process high CPU utilization  (Tom Lane, )
              Re: stats collector process high CPU utilization  (Tom Lane, )
               Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                Re: stats collector process high CPU utilization  (Tom Lane, )
                 Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                  Re: stats collector process high CPU utilization  (Tom Lane, )
                   Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                   Re: stats collector process high CPU utilization  ("Merlin Moncure", )
                    Re: stats collector process high CPU utilization  (Tom Lane, )
                     Re: stats collector process high CPU utilization  ("Merlin Moncure", )
                      Re: stats collector process high CPU utilization  (Tom Lane, )
                       Re: stats collector process high CPU utilization  (Magnus Hagander, )
                   Re: stats collector process high CPU utilization  (Bruce Momjian, )
                    Re: stats collector process high CPU utilization  ("Joshua D. Drake", )

Tom Lane wrote:
>  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?

No idea.  I do have a very crude piece of code to read a pgstat.stat
file and output some info about what it finds (table OIDs basically
IIRC).  Maybe it can be helpful to examine what's in the bloated stat
file.

Regarding temp tables, I'd think that the pgstat entries should be
getting dropped at some point in both releases.  Maybe there's a bug
preventing that in 8.2?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-performance по дате сообщения:

От: Mark Stosberg
Дата:
Сообщение: cube operations slower than geo_distance() on production server
От: Mark Stosberg
Дата:
Сообщение: Re: Can anyone make this code tighter? Too slow, Please help!