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 199908201344.JAA08444@osprey.astro.umass.edu
Whole thread Raw
In response to Re: [GENERAL] [Fwd: Maximum filesize of one file]  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-general
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 files are
>> approaching 1GB not 2GB.
>
> I think so.

Peter Mount wrote on Mon, 16 Aug 1999 14:37:06 EDT
> It should do, as it's the StorageManager that does the splitting, and
> tables/indices both use the StorageManager.
>
> This also includes the current LargeObject implementation, as they are
> currently implemented as a table/index pair.

I build a large database and index to test this and, yes, indeed
it *DOES WORK*.

Thanks to Peter Mount and Bruce Momjian for their quick replies
and info.

I will be contructing 100 GB database in the next few weeks.  I
try to post some scaling stats when it's up and running.

--Martin


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

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: Dirk Lutzebaeck
Date:
Subject: backend crashing with INTERSECT / ORDER BY
Next
From: "amy cheng"
Date:
Subject: Re: [GENERAL] Trigger documentation? Need more examples.. pleeeze.. ;-)