Hello all! Ok, i found out some more informations. According to http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us& taskId=110&prodSeriesId=397634&prodTypeId=15351&prodSeriesId=397634&objectID =PSD_EX050119_CW01 one of our four disks in the server has a firmware issue. The problem are incomplete writes onto disk while on high I/O load... We will check this one first. If it won't help, we will try the hardware diagnostics and some other tests... Meanwhile thank you all for your suggestions :)
-- Matthias > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, September 20, 2006 3:14 PM > To: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Strange database corruption with > PostgreSQL 7.4.x o > > > Hello Scott! > > Thank you for the quick answer. I'll try to check our > hardware which is a > Compaq DL380 G4 with a batteyr buffered write cache on our > raid controller. > As the system is running stable at all i think it's not the > cpu or memory. > At moment i tend more to a bad disk or SCSI controller but > even with that i > don't get any message in my logs... > Any ideas how i could check the hardware? > > Best regards, > Matthias > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match