Re: Maximum Number of Tables in a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brubaker, Shane" <Shane_Brubaker(at)affymetrix(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Cawley, Simon" <Simon_Cawley(at)affymetrix(dot)com>
Subject: Re: Maximum Number of Tables in a database
Date: 2002-07-25 15:31:53
Message-ID: 18728.1027611113@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

  • PL/pgSQL at 2002-07-26 13:52:04 from Heni Lolov

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Ruprecht 2002-07-25 16:50:30 OS File Size > 1GB
Previous Message Michael G. Martin 2002-07-25 03:01:35 Re: Postgres performance slowly gets worse over a month