Re: database corruption

From: Amadeus Zilfinski <amadeus0(at)cox(dot)net>
To: Ian Westmacott <ianw(at)intellivid(dot)com>
Cc: Chris Travers <chris(at)travelamericas(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: database corruption
Date: 2005-04-16 16:37:28
Message-ID: 1113669448.6483.4.camel@fileserver01.batrender
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

,snipped.
> - SuSE 9.1
> - 2.6.6 kernel
> - Postgres 7.4.2
> - 300 TPS against DB containing 5-50GB data, no more than a dozen
> concurrent connections.
> - fsync (or not) and fdatasync

I remember a problem that was fixed in the 2.6.9 kernel concerning XFS
corruption (shutdowns I think were the worst). Also introduced some JFS
stuff, but I don't run JFS so I didn't really pay much attention to
that.

Can you try a later (the latest?) vanilla kernel?

AmadeusZ.-

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sanjay tumula 2005-04-17 05:54:05 performance problem
Previous Message Joel Fradkin 2005-04-16 13:39:17 Re: Help installing 8.0.2 rpms on RH 3.0