Adriaan van Os wrote: > Tom Lane wrote: > >> Somehow, autovac is doing something that makes the filesystem go nuts >> every so often, and take an astonishingly long time to create an empty >> file. But autovac itself doesn't create or delete any files, so what's >> up here? >> Also, I was able to reproduce the variability in timing on HPUX and >> Darwin as well as Linux, so we can't put all the blame on ext3. >> (I didn't drill down to the strace level on the other two machines, >> though, so it's possible that there is a different mechanism at work >> there.) > > Any news since this message ? Should I file a bug report ? Were you able to show that turning off autovacuum removes the performance problem? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
