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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Disk filling, CPU filling, renegade inserts and deletes?
Дата
Msg-id 20050421204618.GD19744@dcc.uchile.cl
обсуждение исходный текст
Ответ на 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
On Thu, Apr 21, 2005 at 11:38:22AM -0700, Richard Plotkin wrote:
> More info on what is bloating:
>
> It's only in one database (the one that's most used), and after running
> oid2name on the bloated files, the result is (mysteriously) empty.
> Here's the run on the three enormous files:
>
> $ /usr/local/bin/oid2name -d smt -o 160779
> From database "smt":
>   Filenode  Table Name
> ----------------------

Try -f instead of -o ...

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"World domination is proceeding according to plan"        (Andrew Morton)

В списке pgsql-performance по дате отправления:

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