Re: Various intermittent bugs/instability - how to debug?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Frederik Ramm" <frederik(dot)ramm(at)geofabrik(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Various intermittent bugs/instability - how to debug?
Date: 2008-09-09 16:24:22
Message-ID: dcc563d10809090924k50ac172eo5033a9c76446de9f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Also, I'd try running a large, long running pgbench test to see if you
get any errors. If such a simple schema / operation in large scale
gets errors it's almost certainly a hardware failure.

Have you had power removed while the system was running? With a lot
of direct attached SATA drives you can get corruption from that as
well due to linux / sata often not obeying write barriers.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Holger Hoffstaette 2008-09-09 16:30:17 Re: PostgreSQL process architecture question.
Previous Message Andrew Sullivan 2008-09-09 16:10:01 Re: PostgreSQL process architecture question.