Re: Disk filling, CPU filling, renegade inserts and

От: Rod Taylor
Тема: Re: Disk filling, CPU filling, renegade inserts and
Дата: ,
Msg-id: 1114025818.66326.34.camel@home
(см: обсуждение, исходный текст)
Ответ на: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin)
Ответы: Re: Disk filling, CPU filling, renegade inserts and  (Richard Plotkin)
Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin)
Список: pgsql-performance

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

Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
 Re: Disk filling, CPU filling, renegade inserts and  (Rod Taylor, )
  Re: Disk filling, CPU filling, renegade inserts and  (Richard Plotkin, )
  Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
 Re: Disk filling, CPU filling, renegade inserts and deletes?  (Tom Lane, )
  Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
   Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
    Re: Disk filling, CPU filling, renegade inserts and deletes?  (Alvaro Herrera, )
     Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
  Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
   Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
    Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
    Re: Disk filling, CPU filling, renegade inserts and deletes?  (Tom Lane, )
     Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
      Re: Disk filling, CPU filling, renegade inserts and deletes?  (Tom Lane, )
       Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )
        Re: Disk filling, CPU filling, renegade inserts and deletes?  (Tom Lane, )
         Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin, )

> I'm having a pretty serious problem with postgresql's performance.
> Currently, I have a cron task that is set to restart and vacuumdb -faz
> every six hours.  If that doesn't happen, the disk goes from 10% full
> to 95% full within 2 days (and it's a 90GB disk...with the database
> being a 2MB download after dump), and the CPU goes from running at
> around a 2% load to a 99+% load right away (the stats look like a
> square wave).

Are you running frequent queries which use temporary tables?


--



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

От: Christopher Kings-Lynne
Дата:
Сообщение: Re: immutable functions vs. join for lookups ?
От: Christopher Browne
Дата:
Сообщение: Re: Opteron vs Xeon