Karl Wright writes:
I'm not writing off autovacuum - just the concept that the large tables aren't the ones that are changing. Unfortunately, they *are* the most dynamically updated.
Would be possible for you to partition the tables?By date or some other fashion to try to have some tables not get affected by the updates/inserts?
I am in the process of breaking a DB.. to have tables by dates. Our historical data never changes.
Also, what is the physical size of all this data?