> The web site lists a lot of the limitations for postgresql,  but not the
> max number of tables that are allowed in a given db.  Anyone care to come
> up with a number?

It is limited by your filesystem's ability to handle large directories.
I have noticed in the past (not with PostgreSQL per se) that ~3000 files
in a directory is noticably slower that a typically small directory.

afaik that is the only real limitation, so you can try some timing and
performance tests using, for example, a perl script to create and access
a large number of files.

                      - Thomas

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to