Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow

Shelby Cain wrote:

> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>>Ah-hah. The win32 hackers should confirm this, but
>>my recollection is
>>that sync/fsync are no-ops under Cygwin (one of the
>>several reasons
>>we would never recommend that port for production
>>use). So this would
>>fit the assumption that the 7.4 code was simply not
>>syncing.
>>
>
>
> Sounds reasonable. However, I don't see the same
> performance hit while doing bulk database operations
> (ie: inserts, deletes, updates). Is that expected
> behavior? Do vacuum operations fsync()/_commit() more
> often?

I think you have other problems around, see the post where
I did some tests.

Regards
Gaetano Mendola