"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:

> Actually, come to think of it, I don't think I'd want any vacuums at all
> on this particular table.  Just the analyze on the primary key, no
> vacuums, no statistics on anything else.  Unfortunately it's not just one
> table, but a set of tables that can be created dynamically.  I could
> change that, but in this particular case I don't think I should.

The way you described it there were records being inserted and later deleted.
Why wouldn't you need vacuums?

Or are all the records eventually deleted and then the table truncated or
dropped before the next batch of inserts?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to