PostgreSQL 11 Administration Cookbook

There's more…

The highest number of distinct, major tables I've ever seen in a database is 20,000, without counting partitions, views, and work tables. That clearly rates as a very complex system:

Number of distinct tables (entities)	Complexity rating
20,000	This is incredibly complex. You're either counting wrong or you have a big team to manage this.
2,000	This is a complex business database. Usually, not many of these are seen.
200	This is a typical modern business database.
20	This is a simple business database.
2	This is a database with a single, clear purpose, strictly designed for performance or some other goal.
0	This tells you that you haven't loaded any data yet!

 

Of course, you can't always easily tell which ...