Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint

Merlin Moncure wrote:
> Kevin Brown wrote:
>
> > I have no idea whether or not this approach would work in Windows.
>
> The win32 API has ReadFileScatter/WriteFileScatter, which was developed
> to handle these types of problems. These two functions were added for
> the sole purpose of making SQL server run faster. They are always
> asynchronous and are very efficient. Perhaps the win32 port could just
> deal with the synchronization with an eye for future optimizations down
> the line?

The problem with the approach I described on win32 is that fast fork()s
are required for it to not significantly impact the running backends.
That is, fork() has to return quickly when called. I don't know whether
the implementation of fork() under win32 would be fast enough for
this purpose. It might be -- I don't have any experience with fork()
on win32 platforms so I can't say.

--
Kevin Brown kevin(at)sysexperts(dot)com