Re: [HACKERS] tables >2GB
Mattias Kregert <matti@algonet.se>
From: Mattias Kregert <matti@algonet.se>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: hackers@postgresql.org
Date: 1998-03-20T11:59:06Z
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 */