Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
> - 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

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


In response to


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group