Re: tuple too big error - Mailing list pgsql-general

From Neil Conway
Subject Re: tuple too big error
Date
Msg-id 20010404082335.F251@klamath.dyndns.org
Whole thread Raw
In response to Re: tuple too big error  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: DaVinci
Date:
Subject: Inheritance and views
Next
From: "Oliver Elphick"
Date:
Subject: Re: Re: unrecognized language plpgsql