Received: from mcs.anl.gov (cliff-32.mcs.anl.gov [140.221.32.31])
	by hub.org (8.9.3/8.9.3) with ESMTP id BAA01911
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 27 Oct 1999 01:43:37 -0400 (EDT)
	(envelope-from selkovjr@xnet.com)
Received: from antares (antares.mcs.anl.gov [140.221.9.6])
	by mcs.anl.gov (8.9.3/8.9.3) with ESMTP id AAA228142;
	Wed, 27 Oct 1999 00:39:58 -0500
Message-Id: <199910270541.AAA25460@antares>
To: pgsql-interfaces@postgreSQL.org, stuart@comodo.net
From: "Gene Selkov, Jr." <selkovjr@mcs.anl.gov>
Subject: Re: [INTERFACES] 8k limit 
In-Reply-To: Your message of "Tue, 26 Oct 1999 12:44:50 -0000."
	<99102612521900.02449@FAETHOR>
Date: Wed, 27 Oct 1999 00:40:58 -0400
Sender: selkovjr@xnet.com

> Next question is whats the max number of large
> objects you can store? I think its about 4 billion , am i wrong?

Don't know the exact theortical limit, but I believe it depends on the
capability of your file system, rather than pointer size and such,
because each lo is a file.

For example, my file system can have 1064960 files in it (one can find
that out with fsck), but the practical constraint will be much
lower. I find it difficult to deal with 30000 files in one directory,
for example. The time it takes to open a file in such directory is
usually on the order of seconds.

--Gene