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 <richard@richardplotkin.com>)
Ответы Re: Disk filling, CPU filling, renegade inserts and deletes?
Список pgsql-performance
Richard Plotkin <richard@richardplotkin.com> 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 по дате отправления:

Предыдущее
От: Richard Plotkin
Дата:
Сообщение: Re: Disk filling, CPU filling, renegade inserts and deletes?
Следующее
От: Richard Plotkin
Дата:
Сообщение: Re: Disk filling, CPU filling, renegade inserts and deletes?