Norbert Meissner wrote:
>
> > > How do you go beyond 2gigs on a single file on ext2fs (like
> > > the major linux distributions delivering) ? magic?
> >
> > Split the files into 1 gig segments.
> >
>
> Excuse my dumb questions, but is this a capability of linux or postgresql ?
> Can you point me to a location where i can read more ?
In Postgresql this is done inside the storage manager. The code is
acrually quite simple amd not hard to read.
The limit now is the OID. This is a 32-bit integer and OIDs are
unique within a database not just a table. (Someone please correct me
if I am wrong) So you can have only 4 giga-rows in a database. Our
project may bump into this limit in a few years but by then maybe
Postgresql will allow 64 bit OIDs
>
> Thanks in advance
> Norbert
--
Chris Albertson
calbertson@logicon.com Voice: 626-351-0089 x17
Logicon, Pasadena California Fax: 626-351-0699