Re: [GENERAL] Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming
Tom Lane <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
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 7: don't forget to increase your free space map settings