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

From Mattias Kregert
Subject Re: [HACKERS] tables >2GB
Date
Msg-id 35125A0A.5FF611AE@algonet.se
Whole thread Raw
In response to Re: [HACKERS] 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.
>
> Can someone knowledgeable make a patch for this for our mega-patch?

But, could it not be useful to be able to use multiple files per
table? Suppose someone wants to spread them out on different
disks to increase access performance?

And what about tables over 2^64 bytes size? There will never be
disks of that size? Now, remember what people said about 2^32 byte
files, and years after 1999, and 64k RAM, and about all inventions
already being invented, and... :)

/* m */

pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: AW: [HACKERS] Begin statement again
Next
From: Massimo Dal Zotto
Date:
Subject: Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6