X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5511C536A0 for ; Wed, 20 Apr 2005 16:39:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22940-02 for ; Wed, 20 Apr 2005 19:39:05 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 275B45367E for ; Wed, 20 Apr 2005 16:39:04 -0300 (ADT) Received: from dyn-70-66.tor.dsl.tht.net (dyn-70-66.tor.dsl.tht.net [134.22.70.66]) by tht.net (Postfix) with ESMTP id 926B176A11; Wed, 20 Apr 2005 15:39:03 -0400 (EDT) Subject: Re: Disk filling, CPU filling, renegade inserts and From: Rod Taylor To: Richard Plotkin Cc: pgsql-performance@postgresql.org In-Reply-To: <6f4567d4e64297b356e2d71ec392cdae@richardplotkin.com> References: <6f4567d4e64297b356e2d71ec392cdae@richardplotkin.com> Content-Type: text/plain Date: Wed, 20 Apr 2005 15:36:58 -0400 Message-Id: <1114025818.66326.34.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/528 X-Sequence-Number: 11925 > 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? --