Postgres Pro
Downloads
Home   >   mailing lists

Re: Disk filling, CPU filling, renegade inserts and deletes? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Disk filling, CPU filling, renegade inserts and deletes?
Date
Msg-id 12016.1114279585@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin <richard@richardplotkin.com>)
Responses Re: Disk filling, CPU filling, renegade inserts and deletes?  (Richard Plotkin <richard@richardplotkin.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Richard Plotkin
Date:
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
Next
From: Richard Plotkin
Date:
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?