Skip site navigation (1) Skip section navigation (2)

Re: Disk filling, CPU filling, renegade inserts and

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Richard Plotkin <richard(at)richardplotkin(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disk filling, CPU filling, renegade inserts and
Date: 2005-04-20 19:36:58
Message-ID: 1114025818.66326.34.camel@home (view raw or flat)
Thread:
Lists: pgsql-performance
> I'm having a pretty serious problem with postgresql's performance.  
> Currently, I have a cron task that is set to restart and vacuumdb -faz 
> every six hours.  If that doesn't happen, the disk goes from 10% full 
> to 95% full within 2 days (and it's a 90GB disk...with the database 
> being a 2MB download after dump), and the CPU goes from running at 
> around a 2% load to a 99+% load right away (the stats look like a 
> square wave).

Are you running frequent queries which use temporary tables?


-- 


In response to

Responses

pgsql-performance by date

Next:From: Joel FradkinDate: 2005-04-20 19:52:45
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Previous:From: Richard PlotkinDate: 2005-04-20 19:28:45
Subject: Disk filling, CPU filling, renegade inserts and deletes?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group