Shelby Cain <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
