Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 662EE475476 for ; Thu, 25 Jul 2002 11:32:50 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g6PFVrVk018729; Thu, 25 Jul 2002 11:31:54 -0400 (EDT) To: "Brubaker, Shane" Cc: pgsql-admin@postgresql.org, "Cawley, Simon" Subject: Re: Maximum Number of Tables in a database In-reply-to: <53386E0C47E7D41194BB0002B325C997747F2B@NTEX60> References: <53386E0C47E7D41194BB0002B325C997747F2B@NTEX60> Comments: In-reply-to "Brubaker, Shane" message dated "Wed, 24 Jul 2002 17:29:38 -0700" Date: Thu, 25 Jul 2002 11:31:53 -0400 Message-ID: <18728.1027611113@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200207/358 X-Sequence-Number: 5042 "Brubaker, Shane" 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