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

Re: Win32 Powerfail testing

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Kevin Brown" <kevin(at)sysexperts(dot)com>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Win32 Powerfail testing
Date: 2003-03-06 08:20:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

> -----Original Message-----
> From: Kevin Brown [mailto:kevin(at)sysexperts(dot)com] 
> Sent: 06 March 2003 04:37
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Win32 Powerfail testing
> Tatsuo Ishii wrote:
> > Sorry, but it does not help. The page says we could use
> > FlushFileBuffers() to sync the kernel buffer to the
> > disk. Unfortunately, it requires a file descriptor to flush for its 
> > argument. Thus it could not be a replacement of sync(). Actually I 
> > have modified the buffer manager so that it remembers all file 
> > descriptors those have not been synced yet to the disk at the 
> > checkpoint time to sync them later. However I found this 
> modification 
> > does not help at all with some reason I don't know.
> It would be an interesting comparison for you to roll the 
> file descriptor tracking changes into the Unix side of the 
> tree and use
> fsync() or fdatasync() in place of FlushFileBuffers() on the 
> Unix side (you'd have to remove or disable the code that does 
> a sync() of course).  If the end result yields no data 
> corruption issues during powerfail testing on various Unix 
> platforms then it's reasonably likely that the problem you're 
> experiencing on the Windows side is with the underlying 
> Windows platform and not with your code.

Agreed, but I still keep thinking that despite some peoples claims that
Windows ain't up to it, DB2, SQL and Exchange Server as well a probably
others that don't use raw partitions have got over this problem, so
therefore we should be able to. Admittedly Microsoft have a bit of an
advantage over us, but there must be some accessible way of flushing the
buffers in a guaranteed way. I'll look into it some more today if I

Regards, Dave.

pgsql-hackers by date

Next:From: btoberDate: 2003-03-06 08:23:14
Subject: Re: My contract has been renewed
Previous:From: Tatsuo IshiiDate: 2003-03-06 08:18:58
Subject: Re: Win32 Powerfail testing

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