On Tue, 2007-05-29 at 19:16 +0200, PFC wrote: > > > Could this be because of my Cost-Based Vacuum Delay settings ? > > Yeah. It is supposed to slow down VACUUM so it doesn't kill your > server, > but it is not aware of the load. It will also slow it down if there is no > load. That is its purpose after all ;) > If you want fast vacuum, issue SET vacuum_cost_delay = 0; before. Thanks, I tried it and it worked. I did not know that changing this setting would result in such a performance drop ( I just followed an advise I read on http://www.powerpostgresql.com/PerfList/) which mentioned a tripling of the the execution time. Not a change from 8201819 ms to 17729 ms.
-- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate