Re: [HACKERS] Problems with >2GB tables on Linux 2.0 - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Date
Msg-id 36BC3797.A103FBA@trust.ee
Whole thread Raw
In response to Problems with >2GB tables on Linux 2.0  (gjerde@icebox.org)
Responses Re: [HACKERS] Problems with >2GB tables on Linux 2.0  (Peter T Mount <peter@retep.org.uk>)
List pgsql-hackers
Thomas Reinke wrote:
> 
> I may be dating myself really badly here, but isn't there a hard limit
> on
> the file system at 2Gig? I thought the file size attribute in Unix is
> represented as a 32 bit signed long, which happens to be a max value
> of 2147483648. If I'm right, it means the problem is fundamentally
> with the file system, not with PostGres, and you won't solve this
> unless the os supports larger files.

There is logic insid PostgreSQL to overflof to nex file at 2GB, but 
apparently this is currently broken.

AFAIK, there are people working on it now

--------------
Hannu


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Optimizer speed and GEQO (was: nested loops in joins)