"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
- PL/pgSQL at 2002-07-26 13:52:04 from Heni Lolov
pgsql-admin by date
|Next:||From: Chris Ruprecht||Date: 2002-07-25 16:50:30|
|Subject: OS File Size > 1GB|
|Previous:||From: Michael G. Martin||Date: 2002-07-25 03:01:35|
|Subject: Re: Postgres performance slowly gets worse over a month|