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 ACA143AAD7B for ; Wed, 15 Dec 2004 00:31:42 +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 28473-09 for ; Wed, 15 Dec 2004 00:31:35 +0000 (GMT) Received: from out-mx.comclark.com (out.comclark.com [202.69.170.99]) by svr1.postgresql.org (Postfix) with ESMTP id B831D3AAD5C for ; Wed, 15 Dec 2004 00:31:37 +0000 (GMT) Received: from avmx.comclark.com (unknown [192.168.3.30]) by out-mx.comclark.com (Postfix) with ESMTP id E89BD16B4A9 for ; Wed, 15 Dec 2004 08:37:57 +0800 (PHT) Received: from localhost (localhost.localdomain [127.0.0.1]) by avmx.comclark.com (Postfix) with ESMTP id A3B0E3DE6AB for ; Tue, 14 Dec 2004 21:40:41 +0800 (PHT) Received: from avmx.comclark.com ([127.0.0.1]) by localhost (avmx.comclark.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15221-04 for ; Tue, 14 Dec 2004 21:40:33 +0800 (PHT) Received: from excalibur (unknown [202.69.190.185]) by avmx.comclark.com (Postfix) with SMTP id AFFA73DE6A4 for ; Tue, 14 Dec 2004 21:40:32 +0800 (PHT) Message-ID: <006201c4e23f$55511250$b9be45ca@excalibur> From: "Philip Michael D Vargas" To: References: <20041210202050.GA12507@mtholyoke.edu> <20041211015056.GA13388@mtholyoke.edu> <20041211195107.GD2668@wolff.to> <20041212035555.GA17165@mtholyoke.edu> <006701c4e00c$1bff1db0$b9be45ca@excalibur> <1103066682.4037.3772.camel@localhost.localdomain> Subject: Re: i need help Date: Wed, 15 Dec 2004 08:45:11 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at comclark.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/130 X-Sequence-Number: 15716 Oh.. Sorry about the details I'm using a ASUS machine with dual processor... 4gb memory... Filesystem 1K-blocks Used Available Use% Mounted on /dev/sdb1 3526172 1132784 2214268 34% / /dev/sda1 248895 8796 227249 4% /boot none 2005700 0 2005700 0% /dev/shm /dev/md0 65757260 52334548 10082408 84% /var /dev/sdc1 17409840 12740248 3785216 78% /backup thank you for your reply... ----- Original Message ----- From: "Simon Riggs" To: "Philip Michael D Vargas" Cc: Sent: Wednesday, December 15, 2004 7:24 AM Subject: Re: [ADMIN] i need help > 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 > >