Philip Warner kirjutas P, 03.11.2002 kell 06:30: > At 09:36 AM 2/11/2002 -0500, Tom Lane wrote: > > >Why not do frequent non-full vacuums on only that table, perhaps every > >five minutes or so? That's certainly the direction that development is > >headed in (we just haven't automated the vacuuming yet). > > Done this now, and I'll wait for a new high load time to see how big the > table gets.
You should find the best interval by testing. I guess the interval could be smaller than 5 min for high loads - I remember testing this situation for getting top update performance when several threads were doing updates at full speed and the best performance was achieved by running a separate backend in a loop that kept doing VACUUM TABLE with only 5 seconds sleep between . ----------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])