Re: [HACKERS] Problems with >2GB tables on Linux 2.0

From: Hannu Krosing <hannu(at)trust(dot)ee>
To: Thomas Reinke <reinke(at)e-softinc(dot)com>
Cc: gjerde(at)icebox(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Date: 1999-02-06 12:37:43
Message-ID: 36BC3797.A103FBA@trust.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-02-06 12:49:03 Re: [HACKERS] Optimizer speed and GEQO (was: nested loops in joins)
Previous Message Michael Meskes 1999-02-06 11:47:32 Re: [HACKERS] DEC OSF1 Compilation problems