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

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

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Date: 2004-08-24 15:12:12
Message-ID: 20040824151212.90135.qmail@web41610.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
--- 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

pgsql-hackers-win32 by date

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

pgsql-general by date

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

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