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