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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shelby Cain <alyandon(at)yahoo(dot)com>
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-20 19:49:33
Message-ID: 1866.1093031373@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> On a hunch, I turned fsync off and the performance
> jumped up to around the same performance I was getting
> running the cygwin 7.4.x port.

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.

			regards, tom lane

In response to

pgsql-hackers-win32 by date

Next:From: Dave PageDate: 2004-08-20 19:56:42
Subject: Re: postmaster.pid
Previous:From: Shelby CainDate: 2004-08-20 19:42:00
Subject: Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming

pgsql-general by date

Next:From: Joe LesterDate: 2004-08-20 19:59:27
Subject: Re: Postgres filling up hard drive with swap files
Previous:From: Tom LaneDate: 2004-08-20 19:43:15
Subject: Re: Postgres filling up hard drive with swap files

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