Re: Large files on linux - Mailing list pgsql-general

From Hans-Jürgen Schönig
Subject Re: Large files on linux
Date
Msg-id 3A354D72.CDB7FE30@cybertec.at
Whole thread Raw
In response to Large files on linux  (Fernan Aguero <fernan@iib.unsam.edu.ar>)
List pgsql-general
Alfred Perlstein schrieb:

> * Fernan Aguero <fernan@iib.unsam.edu.ar> [001211 12:45] wrote:
> > Dear all:
> >
> > I am having trouble with large files on a Linux box (RH 6.2). I know there
> > is a limit of 2 GB on the file size, but do not know if this is kernel
> > related, filesystem related or both.
>
> Afaik it's both.
>
> Honestly Postgresql should be able to deal with this limitation by
> using more than one file per table.
>
> But if you really want to support large files on a free UNIX,
> I'd try FreeBSD.
>
> best of luck,
> --
> -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
> "I have the heart of a child; I keep it in a jar on my desk."

Kernel >= 2.4 can manage large files. As far as I have tried this it works
perfectly well.

    Hans



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Large files on linux
Next
From: Joe Kislo
Date:
Subject: Re: Unanswered questions about Postgre