Re: [HACKERS] tables >2GB - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] tables >2GB
Date
Msg-id 34D02EDE.CC9EFBA8@sable.krasnoyarsk.su
Whole thread Raw
In response to tables >2GB  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
>
> Now that we know the storage manager code that splits tables over 2GB
> into separate files doesn't work(Irix), can we rip out that code and
> just use the OS code to access >2GB files as normal files.  Now, most
> OS's can support 64-bit files and file sizes.
>
> Because it is isolated in the storage manager, it should be easy.

Someday we'll get TABLESPACEs and fixed multi-chunk code could
allow to store chunks in different TABLESPACEs created on _different
disks_ - imho, ability to store a table on > 1 disk is good thing.

And so, I would suggest just add elog(ERROR) to mdextend() now,
with recommendation to increase RELSEG_SIZE...

Vadim

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: tables >2GB
Next
From: "Alexandr V. Goncharuk"
Date:
Subject: (no subject)