On Wed, Jun 09, 2004 at 13:41:27 -0400, [EMAIL PROTECTED] wrote: > > Sigh, because vacuums take away from performance. Imagine a table that has > to be updated on the order of a few thousand times a minute. Think about > the drop in performance during the vacuum. > > On a one row table, vacuum is not so bad, but try some benchmarks on a > table with a goodly number of rows.
But you only need to rapidly vacuum the one table that is keeping your totals record. This isn't going to be a big hit in performance relative to the updates that are going on. You don't need to vacuum the tables you are doing the inserts or updates to at that same rate. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
