Re: [HACKERS] tables >2GB

From: Mattias Kregert <matti(at)algonet(dot)se>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] tables >2GB
Date: 1998-03-20 11:59:06
Message-ID: 35125A0A.5FF611AE@algonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 */

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1998-03-20 12:57:02 Re: AW: [HACKERS] Begin statement again
Previous Message Massimo Dal Zotto 1998-03-20 10:59:01 Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6