Re: Total crash of my db-server - Mailing list pgsql-general

From Kevin Brown
Subject Re: Total crash of my db-server
Date
Msg-id 20021216231517.GC20180@filer
Whole thread Raw
In response to Re: Total crash of my db-server  ("Henrik Steffen" <steffen@city-map.de>)
Responses Re: Total crash of my db-server  (<terry@ashtonwoodshomes.com>)
Server testing.  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Henrik Steffen wrote:
> In my opinion, postgresql does something on my machine
> that leads to these complete system lockups.

PostgreSQL might beat on the disk subsystem hard enough to show faults
in it, or perhaps it uses enough CPU that the CPU isn't being cooled
properly anymore, etc.

But regardless, that only means that PostgreSQL is a trigger, not an
actual root cause.  And it means that you will almost certainly have
problems even after switching database engines.

You mentioned that you're using a hardware RAID controller.  There is
always the possibility that the driver for that controller isn't
entirely stable.

If you have an identical box you can drop in place, I highly recommend
that you do so.  I'm betting that your problems will disappear after
you do that.


--
Kevin Brown                          kevin@sysexperts.com

pgsql-general by date:

Previous
From: Kevin Brown
Date:
Subject: Re: Total crash of my db-server
Next
From: Stephan Szabo
Date:
Subject: Re: Returning multiple columns with a function??