Re: tuple too big error

On Wed, Apr 04, 2001 at 06:45:39PM +1000, Gavin Sherry wrote:
> Main problem with large objects with postgres 7.0 series (and before
> this) is that ext2 does not scale well when number of hard links in a
> given directory grows to anything like what I would expect a database with
> DNA sequences in it would require.
>
> I believe some directory splitting was planned for 7.1 release but I have
> not seen this in the beta releases.

AFAIK, in 7.1 LOs are all stored in a single file, so this is no longer
a concern.

You could also use a filesystem without the O(n) directory lookup of
traditional UNIX filesystems: I think ReiserFS has this, but I'm not
sure.

Cheers,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

I've made up my mind.  Don't try to confuse me with the facts.
        -- Indiana Senator Earl Landgrebe