Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group