Andrew McMillan <[EMAIL PROTECTED]> writes: > On Fri, 2005-07-29 at 09:37 -0800, Matthew Schumacher wrote: >> How often should this table be vacuumed, every 5 minutes?
> I would be tempted to vacuum after each e-mail, in this case. Perhaps the bulk of the transient states should be done in a temp table, and only write into a real table when you're done? Dropping a temp table is way quicker than vacuuming it ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org