William Yu <wyu(at)talisys(dot)com> 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