--- 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?

Regards,

Shelby Cain


	
		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

Responses

• Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow at 2004-08-24 16:02:17 from Gaetano Mendola
• Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming at 2004-08-24 16:11:00 from Tom Lane

pgsql-hackers-win32 by date

Next:	From: Vidyasagara Guntaka	Date: 2004-08-24 15:23:37
	Subject: Not able to build libpq for Windows using 8.0.0 beta1
Previous:	From: Dave Page	Date: 2004-08-24 14:55:20
	Subject: Re: postmaster.pid

pgsql-general by date

Next:	From: Vidyasagara Guntaka	Date: 2004-08-24 15:23:37
	Subject: Not able to build libpq for Windows using 8.0.0 beta1
Previous:	From: Tom Lane	Date: 2004-08-24 15:04:49
	Subject: Re: pg_dump in stand alone backend