pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>
>




view thread (3+ messages)

Message-ID: <006201c4e23f$55511250$b9be45ca@excalibur>
Permalink:  ../006201c4e23f$55511250$b9be45ca@excalibur/
Also on:    postgresql.org/message-id/006201c4e23f$55511250$b9be45ca@excalibur

 · 

reply

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