From: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
To: pgsql-interfaces@postgreSQL.org
To: stuart@comodo.net
Subject: Re: [INTERFACES] 8k limit
Date: Wed, 27 Oct 1999 00:40:58 -0400
Message-ID: <199910270541.AAA25460@antares> (raw)
In-Reply-To: <99102612521900.02449@FAETHOR>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: selkovjr@mcs.anl.gov, stuart@comodo.net
Subject: Re: [INTERFACES] 8k limit
In-Reply-To: <199910270541.AAA25460@antares>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox