Re: Postgresql limits - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgresql limits
Date
Msg-id 14558.984681083@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql limits  (Gunnar Lindholm <gunix@telia.com>)
List pgsql-admin
Gunnar Lindholm <gunix@telia.com> writes:
> I would like to know some what the maximum number of tables and
> databases that postgresql version 7.X supports.

There's no specific upper limit on either.  You might start noticing
performance problems (due to OS directory lookups) above a few thousand
tables, depending on how well your filesystem copes with lots of files
in a directory.

            regards, tom lane

pgsql-admin by date:

Previous
From: Gunnar Lindholm
Date:
Subject: Postgresql limits
Next
From: "Metzidis, Anthony"
Date:
Subject: psql bug? Segfault from source users != dest users