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?


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to