Re: Postgresql limits

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gunix(at)telia(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql limits
Date: 2001-03-15 18:31:23
Message-ID: 14558.984681083@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Gunnar Lindholm <gunix(at)telia(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Metzidis, Anthony 2001-03-15 19:17:16 psql bug? Segfault from source users != dest users
Previous Message Gunnar Lindholm 2001-03-15 17:59:12 Postgresql limits