PostgreSQL at 10TB and Beyond

But for reference:

1. Table partitioning was used to solve autovacuum and statistical correlation problems on the work tables

2. Non-1NF designs need to understand atomicity as being relational and not ontological in nature. I.e. what you are doing with the data determines atomicity far more than the data itself, and

3. Immutable functions and functional indexes rock on PostgreSQL.

Also I cannot stress enough the need for doing real monitoring and simulation of problems.

https://lists.postgresql.org/mj/mj_wwwusr?user=&passw=&func=...