Benjamin Arai wrote:
What is the current maximum number of tables per database? Also, does having more tables slow down performance in any way?
For most cases, the answer is no. However, once you get near 6 figure table counts, pg_catalog ends up being pretty massive. The problem is that the query planner must check pg_catalog for every query to see what indexes are available, what the statistics & value distributions are, etc. in order to build the optimal plan. At some point, a really large pg_catalog can begin to bog down your system.
See the performance list for a recent discussion about this very issue.
