Re: Occasional giant spikes in CPU load

От: Tom Lane
Тема: Re: Occasional giant spikes in CPU load
Дата: ,
Msg-id: 23596.1277438692@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Occasional giant spikes in CPU load  (Craig James)
Ответы: Re: Occasional giant spikes in CPU load  (Craig James)
Список: pgsql-performance

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

indexes in partitioned tables - again  (Samuel Gendler, )
 Re: indexes in partitioned tables - again  (Robert Haas, )
  Occasional giant spikes in CPU load  (Craig James, )
   Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )
    Re: Occasional giant spikes in CPU load  (Craig James, )
     Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )
      Re: Occasional giant spikes in CPU load  (Craig James, )
       Re: Occasional giant spikes in CPU load  (David Rees, )
       Re: Occasional giant spikes in CPU load  (Tom Lane, )
       Re: Occasional giant spikes in CPU load  (Alan Hodgson, )
     Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )
   Re: Occasional giant spikes in CPU load  (Greg Smith, )
   Re: Occasional giant spikes in CPU load  (Tom Lane, )
    Re: Occasional giant spikes in CPU load  (Craig James, )
     Re: Occasional giant spikes in CPU load  (Steve Crawford, )
   Re: Occasional giant spikes in CPU load  (David Rees, )
    Re: Occasional giant spikes in CPU load  (Robert Haas, )
     Re: Occasional giant spikes in CPU load  (Craig James, )
      Re: Occasional giant spikes in CPU load  (David Rees, )
       Re: Occasional giant spikes in CPU load  (Robert Haas, )
        Re: Occasional giant spikes in CPU load  (Craig James, )
         Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )
         Re: Occasional giant spikes in CPU load  (Greg Smith, )
         Re: Occasional giant spikes in CPU load  (Tom Lane, )
          Re: Occasional giant spikes in CPU load  (Craig James, )
           Re: Occasional giant spikes in CPU load  (Tom Lane, )
            Re: Occasional giant spikes in CPU load  (Craig James, )
             Re: Occasional giant spikes in CPU load  ("Kevin Grittner", )
              Re: Occasional giant spikes in CPU load  (Craig James, )
             Re: Occasional giant spikes in CPU load  (Greg Smith, )
             Re: Occasional giant spikes in CPU load  (Tom Lane, )
              pgbench results on a new server  (Craig James, )
               Re: pgbench results on a new server  (Scott Marlowe, )
               Re: pgbench results on a new server  (Greg Smith, )
                Re: pgbench results on a new server  (Craig James, )
                 Re: pgbench results on a new server  (Merlin Moncure, )
                  Two fast searches turn slow when used with OR clause  (Craig James, )
                   Re: Two fast searches turn slow when used with OR clause  (Robert Haas, )
                 Re: pgbench results on a new server  (Greg Smith, )
           Re: Occasional giant spikes in CPU load  (Rajesh Kumar Mallah, )
         Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )
      Re: Occasional giant spikes in CPU load  (Bruce Momjian, )
    Re: Occasional giant spikes in CPU load  (Greg Smith, )
   Re: Occasional giant spikes in CPU load  ("Joshua D. Drake", )

Craig James <> writes:
> So what is it that will cause every single Postgres backend to come to life at the same moment, when there's no real
loadon the server?  Maybe if a backend crashes?  Some other problem? 

sinval queue overflow comes to mind ... although that really shouldn't
happen if there's "no real load" on the server.  What PG version is
this?  Also, the pg_stat_activity view contents when this happens would
probably be more useful to look at than "top" output.

            regards, tom lane


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

От: Rajesh Kumar Mallah
Дата:
Сообщение: sudden spurt in swap utilization (was:cpu bound postgresql setup.)
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)