X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4060C3AAB5E for ; Tue, 14 Dec 2004 23:28:39 +0000 (GMT) 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 09417-05 for ; Tue, 14 Dec 2004 23:28:32 +0000 (GMT) Received: from cmailm4.svr.pol.co.uk (cmailm4.svr.pol.co.uk [195.92.193.211]) by svr1.postgresql.org (Postfix) with ESMTP id 65D343AAB4D for ; Tue, 14 Dec 2004 23:28:33 +0000 (GMT) Received: from modem-3156.lynx.dialup.pol.co.uk ([217.135.204.84] helo=[192.168.0.102]) by cmailm4.svr.pol.co.uk with esmtp (Exim 4.41) id 1CeM5o-0007bh-VI; Tue, 14 Dec 2004 23:28:33 +0000 Subject: Re: i need help From: Simon Riggs To: Philip Michael D Vargas Cc: pgsql-admin@postgresql.org In-Reply-To: <006701c4e00c$1bff1db0$b9be45ca@excalibur> References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> <20041211195107.GD2668@wolff.to> <20041212035555.GA17165@mtholyoke.edu> <006701c4e00c$1bff1db0$b9be45ca@excalibur> Content-Type: text/plain Organization: 2nd Quadrant Message-Id: <1103066682.4037.3772.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 14 Dec 2004 23:24:42 +0000 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: 200412/128 X-Sequence-Number: 15714 On Sun, 2004-12-12 at 05:33, Philip Michael D Vargas wrote: > Good day to all ... > > I hope any one can give me an advice ... to optimize my database... > > im having a problem when i'm backing up my DB and also using vacuum for my > DB... > my CPU load goes up.... and no one can use my DB... most of the transaction > comes from web server.. > > I just need ur good advice ... Consider increasing shared_buffers, but consider what your RAM is before you do that. You'll need to give reasonable details if you want good help. The specific details are important in knowing what might be causing your problem. There is much good advice available already and the manuals are good too... -- Best Regards, Simon Riggs