From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: tuple too big error |
Date: | 2001-04-04 12:23:35 |
Message-ID: | 20010404082335.F251@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)home(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | roy cabaniss | 2001-04-04 12:31:30 | converting from php3 to php4 |
Previous Message | DaVinci | 2001-04-04 12:07:13 | Inheritance and views |