Re: Load distributed checkpoint - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Load distributed checkpoint
Date
Msg-id 20061220134846.GF12639@svana.org
Whole thread Raw
In response to Re: Load distributed checkpoint  ("Takayuki Tsunakawa" <tsunakawa.takay@jp.fujitsu.com>)
List pgsql-hackers
On Wed, Dec 20, 2006 at 09:14:50PM +0900, Takayuki Tsunakawa wrote:
> > That implies that fsyncing a datafile blocks fsyncing the WAL. That
> > seems terribly unlikely (although...). What OS/Kernel/Filesystem is
> > this. I note a sync bug in linux for ext3 that may have relevence.
>
> Oh, really?  What bug?  I've heard that ext3 reports wrong data to
> iostat when it performs writes (the data is correct when performing
> reads.)

I was referring to this in the 2.6.6 changelog:

http://www.linuxhq.com/kernel/changelog/v2.6/6/index.html
  ext3's fsync/fdatasync implementation is currently syncing the inode via a  full journal commit even if it was
unaltered.  
However you're running a later version so that's not it.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
Next
From: Peter Eisentraut
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2