From: Philip Michael D Vargas <pmdv@comclark.com>
To: pgsql-admin@postgresql.org
Subject: Re: i need help
Date: Wed, 15 Dec 2004 08:45:11 +0800
Message-ID: <006201c4e23f$55511250$b9be45ca@excalibur> (raw)
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>
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" <simon@2ndquadrant.com>
To: "Philip Michael D Vargas" <pmdv@comclark.com>
Cc: <pgsql-admin@postgresql.org>
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
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pmdv@comclark.com
Subject: Re: i need help
In-Reply-To: <006201c4e23f$55511250$b9be45ca@excalibur>
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> <006201c4e23f$55511250$b9be45ca@excalibur>
* 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