Re: [GENERAL] [Fwd: Maximum filesize of one file]

1999-08-20 Thread Martin Weinberg
Bruce Momjian wrote on Mon, 16 Aug 1999 14:24:57 EDT >> [. . .] >> Currently, pgsql 6.5.x breaks up the files containing >> tables into roughly 1 GB chunks. My question is: will >> pgsql do the same for the files containing the indices? >> >> Correction to info in my previous post: my index fil

Re: [GENERAL] [Fwd: Maximum filesize of one file]

1999-08-16 Thread Peter Mount
On Mon, 16 Aug 1999, Martin Weinberg wrote: > Currently, pgsql 6.5.x breaks up the files containing > tables into roughly 1 GB chunks. My question is: will > pgsql do the same for the files containing the indices? It should do, as it's the StorageManager that does the splitting, and tables/ind

Re: [GENERAL] [Fwd: Maximum filesize of one file]

1999-08-16 Thread Bruce Momjian
> Dear CN, > > Yes, thanks for you message. I am well aware of the > 32 bit=2GB limitation in the ext2fs. > > Currently, pgsql 6.5.x breaks up the files containing > tables into roughly 1 GB chunks. My question is: will > pgsql do the same for the files containing the indices? > > Correction

Re: [GENERAL] [Fwd: Maximum filesize of one file]

1999-08-16 Thread Martin Weinberg
Dear CN, Yes, thanks for you message. I am well aware of the 32 bit=2GB limitation in the ext2fs. Currently, pgsql 6.5.x breaks up the files containing tables into roughly 1 GB chunks. My question is: will pgsql do the same for the files containing the indices? Correction to info in my previ

[GENERAL] [Fwd: Maximum filesize of one file]

1999-08-15 Thread CN Liu
> I have a 40 million record database (about 40GB and growing) and I > notice that some of my multicolumn indices are beginning to approach > 2GB on disk. > > Will there be any problems spanning the 32 bit limit here (a la tables > in version 6.4)? Please refer to the attached messages from [EMA