Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow
Date
Msg-id cgfoqd$6vk$2@floppy.pyrenet.fr
Whole thread Raw
In response to Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming  (Shelby Cain <alyandon@yahoo.com>)
List pgsql-general
Shelby Cain wrote:

> --- Tom Lane <tgl@sss.pgh.pa.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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Invalid input for integer on VIEW
Next
From: Silvio Matthes
Date:
Subject: WG: Re: Re: select ... where ='' does a seqscan [auf Viren geprueft]