On October 15th, 2007 Markus Schaber (not verified) says:
Hi,
PostgreSQL used to suffer from that up until the 7.X aera, vacuuming was just frightening.
But today, that's not true any more, the newer releases have the possibility to configure Vacuum in a much more polite way, so it doesn't interfere with normal operation any more.
And the new 8.3 release even avoids explicit vacuuming in some cases (a neat side-effect of the HOT patch), and allows parallel vacuum on different tables etc.
PostgreSQL has vastly increased in that area
Hi,
PostgreSQL used to suffer from that up until the 7.X aera, vacuuming was just frightening.
But today, that's not true any more, the newer releases have the possibility to configure Vacuum in a much more polite way, so it doesn't interfere with normal operation any more.
And the new 8.3 release even avoids explicit vacuuming in some cases (a neat side-effect of the HOT patch), and allows parallel vacuum on different tables etc.