DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=googlemail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=gUabGgWu45/N7XVfM0O3lY/GW4RvCKWibYku3bw7BHdD3WO/75Bpm5ZG/HwjaFUB1thx+P1kCF+oqCrP4fQfDt9mXSUon+qbXmKry8XYBDJP4aMEE0sNQ2A24wo66CeEwux8Dl4dfeEC/lQGuM9Fw/zJzBiMfhuROv3r2ZxsgBo=
Message-ID: <c244500b0512160515p23eafee2u@mail.gmail.com>
Date: Fri, 16 Dec 2005 14:15:58 +0100
From: Moritz Bayer <moritz.bayer@googlemail.com>
To: pgsql-performance@postgresql.org
Subject: Crashing DB or Server?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5127_8563544.1134738958471"

------=_Part_5127_8563544.1134738958471
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello group,

I've got a really bad problem with my postgres DB and server.
It is a linux machine with 1GB of RAM and 2 CPUs.
The postgres Version is 7.4.

The problem is, that once the postmaster has started, the System is just
about useless. At least querys to the db are so slow, that it most often
runs into timeouts. First I thought something was wrong with my querys or I
forgot to close the connections. But this isn't the case, I cut all the
connections to the server so that there are no incoming requests. Still,
once I start the postmaster and look into the statistics of the top-command=
,
the IOWAIT parameter of all CPUs are at about 100%.

This is really weird, just a few hours ago the machine run very smooth
serving the data for a big portal.

Has anybody an idea what might have happened here?
I need a quick solution, since I'm talking about an live server that should
be running 24 hours a day.

Thanks in advance,
Moritz

PS: I'm not a administrator so I don't know if I have wrote down all the
relevant data. If not, please ask for it and give me a hint how to get them

------=_Part_5127_8563544.1134738958471
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello group,<br>
<br>
I've got a really bad problem with my postgres DB and server.<br>
It is a linux machine with 1GB of RAM and 2 CPUs.<br>
The postgres Version is 7.4.<br>
<br>
The problem is, that once the postmaster has started, the System is
just about useless. At least querys to the db are so slow, that it most
often runs into timeouts. First I thought something was wrong with my
querys or I forgot to close the connections. But this isn't the case, I
cut all the connections to the server so that there are no incoming
requests. Still, once I start the postmaster and look into the
statistics of the top-command, the IOWAIT parameter of all CPUs are at
about 100%. <br>
<br>
This is really weird, just a few hours ago the machine run very smooth serv=
ing the data for a big portal.<br>
<br>
Has anybody an idea what might have happened here?<br>
I need a quick solution, since I'm talking about an live server that should=
 be running 24 hours a day.<br>
<br>
Thanks in advance,<br>
Moritz<br>
<br>
PS: I'm not a administrator so I don't know if I have wrote down all
the relevant data. If not, please ask for it and give me a hint how to
get them<br>
<br>
<br>


------=_Part_5127_8563544.1134738958471--