X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1969E9FB200 for ; Tue, 11 Jul 2006 22:32:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91724-09 for ; Tue, 11 Jul 2006 22:32:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 4FE189FA5CD for ; Tue, 11 Jul 2006 22:32:22 -0300 (ADT) Received: (qmail 8830 invoked by uid 500); 12 Jul 2006 01:37:21 -0000 Date: Tue, 11 Jul 2006 20:37:21 -0500 From: Bruno Wolff III To: Neil Hepworth Cc: Jeff Frost , pgsql-performance@postgresql.org Subject: Re: High CPU Usage - PostgreSQL 7.3 Message-ID: <20060712013721.GA8481@wolff.to> Mail-Followup-To: Bruno Wolff III , Neil Hepworth , Jeff Frost , pgsql-performance@postgresql.org References: <5a6f767a0607091752y5018f9eaw474dc5cf7de3c4c3@mail.gmail.com> <5a6f767a0607100055w2677d4c2u8597e394206e86d1@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5a6f767a0607100055w2677d4c2u8597e394206e86d1@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/96 X-Sequence-Number: 19956 On Mon, Jul 10, 2006 at 17:55:38 +1000, Neil Hepworth wrote: > > running on our server (obviously we need to update certain queries, > e.g. delete .. using.. and test with 8.1 first) - I will be pushing > for an upgrade as soon as possible. And the fsync=false is a You can set add_missing_from if you want to delay rewriting queries that use that feature.