"Brubaker, Shane" <Shane_Brubaker(at)affymetrix(dot)com> writes:
> So I'm assuming there is no practical limit on the number of tables in a
> given database.
The practical limit depends on how well your kernel copes with
directories containing large numbers of files (since PG stores each
table as a file within the directory for the database). Many Unixen
start to get pretty slow with more than a few thousand files in a
directory, because they do directory lookups by linear search.
regards, tom lane