Re: i need help - Mailing list pgsql-admin

From Philip Michael D Vargas
Subject Re: i need help
Date
Msg-id 006201c4e23f$55511250$b9be45ca@excalibur
Whole thread Raw
In response to fallback authentication  (Ron Peterson <rpeterso@mtholyoke.edu>)
List pgsql-admin
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
>
>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bind PostgreSQL to a specific IP
Next
From: "Iain"
Date:
Subject: Re: Tyan Thunder MB for postgres server