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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
