Re: [GENERAL] Indexes and Tables: Growth and Treatment

2004-07-21 Thread Thomas F . O'Connell
On Jul 18, 2004, at 6:46 PM, Matthew T. O'Connor wrote: Regular vacuum will (almost) never return your table to it's minimum size. I don't think it's unreasonable for a table that is 4MB after a vacuum full, to grow to 11MB, especially if it's a very active table. That's good to know. The importan

Re: Fwd: [GENERAL] Indexes and Tables: Growth and Treatment

2004-07-18 Thread Matthew T. O'Connor
Regular vacuum will (almost) never return your table to it's minimum size. I don't think it's unreasonable for a table that is 4MB after a vacuum full, to grow to 11MB, especially if it's a very active table. The important question is does it keep growing? Or does it reach a steady state size?