William Yu <wyu@xxxxxxxxxxx> writes: > 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. You also have to think about the performance implications of having tens of thousands of files in your database directory. While some newer filesystems aren't fazed by that particularly, a lot of 'em bog down on lookups when there are more than a few thousand entries in a directory. regards, tom lane
