Re: [GENERAL] [Fwd: Maximum filesize of one file] - Mailing list pgsql-general

From Martin Weinberg
Subject Re: [GENERAL] [Fwd: Maximum filesize of one file]
Date
Msg-id 199908161815.OAA21358@osprey.astro.umass.edu
Whole thread Raw
In response to [Fwd: Maximum filesize of one file]  (CN Liu <cn@mail.sinyih.com.tw>)
Responses Re: [GENERAL] [Fwd: Maximum filesize of one file]  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [GENERAL] [Fwd: Maximum filesize of one file]  (Peter Mount <peter@retep.org.uk>)
List pgsql-general
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 previous post: my index files are
approaching 1GB not 2GB.

--Martin

CN Liu wrote on Mon, 16 Aug 1999 11:47:11 +0800
>This is a multi-part message in MIME format.
>--------------01A497728CDC1E265B4A5A80
>Content-Type: text/plain; charset=big5
>Content-Transfer-Encoding: 7bit
>
>> 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 linux-raid@vger.rutgers.edu.
>
>CN
>
> [SNIP . . .]

===========================================================================

Martin Weinberg                      Phone: (413) 545-3821
Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA  01003-4525

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] FATAL 1: my bits moved right off the end of the world!
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] [Fwd: Maximum filesize of one file]