Re: [HACKERS] Linux Largefile Support In Postgresql RPMS

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, PostgresSQL General Mailing List <pgsql-general(at)postgresql(dot)org>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Linux Largefile Support In Postgresql RPMS
Date: 2002-08-13 02:57:51
Message-ID: 1029207472.4796.254.camel@mouse.copelandconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, 2002-08-12 at 18:41, Martijn van Oosterhout wrote:
> On Mon, Aug 12, 2002 at 11:30:36AM -0400, Andrew Sullivan wrote:
> > The problem is not just a system-level one, but a filesystem-level
> > one. Enabling 64 bits by default might be dangerous, because a DBA
> > might think "oh, it supports largefiles by default" and therefore not
> > notice that the filesystem itself is not mounted with largefile
> > support. But I suspect that the developers would welcome autoconfig
> > patches if someone offered them.
>
> Are there any filesystems in common use (not including windows ones) that
> don't support >32-bit filesizes?
>
> Linux (ext2) I know supports by default at least to 2TB (2^32 x 512bytes),
> probably much more. What about the BSDs? XFS? etc
>

Ext2 & 3 should be okay. XFS (very sure) and JFS (reasonably sure)
should also be okay...IIRC. NFS and SMB are probably problematic, but I
can't see anyone really wanting to do this. Maybe some of the
clustering file systems (GFS, etc) might have problems??? I'm not sure
where reiserfs falls. I *think* it's not a problem but something
tingles in the back of my brain that there may be problems lurking...

Just for the heck of it, I did some searching. Found these for
starters:
http://www.suse.de/~aj/linux_lfs.html.
http://www.gelato.unsw.edu.au/~peterc/lfs.html

http://ftp.sas.com/standards/large.file/

So, in a nut shell, most modern (2.4.x+) x86 Linux systems should be
able to handle large files.

Enjoy,
Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2002-08-13 03:04:09 Re: Slow deletes
Previous Message Tom Lane 2002-08-13 02:57:02 Re: Slow deletes

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-08-13 03:56:34 Re: [COMMITTERS] pgsql-server/src backend/tcop/postgres.cbacke
Previous Message Lamar Owen 2002-08-13 02:49:37 Re: Open 7.3 items