From: Richard Plotkin <richard@richardplotkin.com>
To: pgsql-performance@postgresql.org
Subject: Re: Disk filling, CPU filling, renegade inserts and
Date: Wed, 20 Apr 2005 13:05:27 -0700
Message-ID: <fac30fdc69bbcd15c385f05b959e758e@richardplotkin.com> (raw)
In-Reply-To: <1114025818.66326.34.camel@home>
References: <6f4567d4e64297b356e2d71ec392cdae@richardplotkin.com>
<1114025818.66326.34.camel@home>
No, I don't think so. I don't think there are any temp table queries
(and I'll check), but even if there are, site traffic is very low, and
queries would be very infrequent.
On Apr 20, 2005, at 12:36 PM, Rod Taylor wrote:
>> 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?
>
>
> --
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: richard@richardplotkin.com
Subject: Re: Disk filling, CPU filling, renegade inserts and
In-Reply-To: <fac30fdc69bbcd15c385f05b959e758e@richardplotkin.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox