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

• Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming at 2004-08-24 15:12:12 from Shelby Cain

Responses

• Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming at 2004-08-24 18:00:00 from Shelby Cain

pgsql-hackers-win32 by date

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

pgsql-general by date

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