Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 25 Jul 2002 11:31:53 -0400
- Message-id: <18728.1027611113@sss.pgh.pa.us> <text/plain>
"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
- Follow-Ups:
- PL/pgSQL
- From: Heni Lolov
- PL/pgSQL
- References:
- Maximum Number of Tables in a database
- From: Brubaker, Shane
- Maximum Number of Tables in a database
- Prev by Date: Re: Postgres performance slowly gets worse over a month
- Next by Date: OS File Size > 1GB
- Previous by thread: Maximum Number of Tables in a database
- Next by thread: PL/pgSQL
- Indexes: