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)
Ответы: 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, )

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 по дате сообщения:

От: Enrico Weigelt
Дата:
Сообщение: foreign key performance
От: "Shoaib Burq (VPAC)"
Дата:
Сообщение: Re: two queries and dual cpu (perplexed)