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-24 16:11:00
Message-ID: 4518.1093363860@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> 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?

IIRC, vacuum fsyncs once per table (possibly more depending on whether
you add FULL, ANALYZE, etc).  Not clear what case you are considering
exactly.

			regards, tom lane

In response to

Responses

pgsql-hackers-win32 by date

Next:From: Andrew DunstanDate: 2004-08-24 17:09:17
Subject: Re: postmaster.pid
Previous:From: Magnus HaganderDate: 2004-08-24 16:06:49
Subject: Re: postmaster.pid

pgsql-general by date

Next:From: Peter EisentrautDate: 2004-08-24 16:13:59
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Richard HuxtonDate: 2004-08-24 16:10:44
Subject: Re: Is it possible...

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