It won't be long for me until that happens. Not long at all. Considering
I've amassed 2.2 GB in just 3-4 weeks....

I'm really surprised to see that Linux has such a lame file limitation. I
think even the macintosh can handle single files in the terabyte range now.

Tim


-----Original Message-----
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Peter T Mount <peter@retep.org.uk>
Cc: perdue@raccoon.com <perdue@raccoon.com>; pgsql-hackers@hub.org
<pgsql-hackers@hub.org>
Date: Wednesday, March 17, 1999 5:29 PM
Subject: Re: [HACKERS] "CANNOT EXTEND" -


>> > pg_dump only dumps a flat unix file.  That can be any size your OS
>> > supports.  It does not segment.  However, a 2gig table will dump to a
>> > much smaller version than 2gig because of the overhead for every
record.
>>
>> Hmmm, I think that, as some people are now using >2Gig tables, we should
>> think of adding segmentation to pg_dump as an option, otherwise this is
>> going to become a real issue at some point.
>
>So the OS doesn't get a table over 2 gigs.  Does anyone have a table
>that dumps a flat file over 2gig's, whose OS can't support files over 2
>gigs.  Never heard of a complaint.
>
>
>>
>> Also, I think we could do with having some standard way of dumping and
>> restoring large objects.
>
>I need to add a separate large object type.
>--
>  Bruce Momjian                        |  http://www.op.net/~candle
>  maillist@candle.pha.pa.us            |  (610) 853-3000
>  +  If your life is a hard drive,     |  830 Blythe Avenue
>  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


Wed, 17 Mar 1999 18:42:47 -0600
"Tim Perdue" <perdue@raccoon.com>
Re: [HACKERS] "CANNOT EXTEND" -
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> It won't be long for me until that happens. Not long at all. Considering
> I've amassed 2.2 GB in just 3-4 weeks....

How large are your flat files.  Also, the postgresql problems are with
files that are exactly 2gig.  It is possible files over that will be ok.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 17 Mar 1999 21:38:48 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] "CANNOT EXTEND" -