Re: Disk filling, CPU filling, renegade inserts and deletes?

От: Tom Lane
Тема: Re: Disk filling, CPU filling, renegade inserts and deletes?
Дата: ,
Msg-id: 12016.1114279585@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Disk filling, CPU filling, renegade inserts and deletes?  (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, )

Richard Plotkin <> writes:
> I updated postgres to 8.0.2, am running vacuumdb -faz every 3 hours,
> and 50 minutes after a vacuum the CPU usage still skyrocketed, and the
> disk started filling.  This time, there is only a single file that is
> spanning multiple GB, but running oid2name again returns no result on
> the oid or filenode.

What is the filename exactly (full path)?

            regards, tom lane


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

От: Josh Berkus
Дата:
Сообщение: Re: Bad n_distinct estimation; hacks suggested?
От: Tom Lane
Дата:
Сообщение: Re: two queries and dual cpu (perplexed)