Re: [HACKERS] "CANNOT EXTEND" -

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(at)candle(dot)pha(dot)pa(dot)us>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: perdue(at)raccoon(dot)com <perdue(at)raccoon(dot)com>; pgsql-hackers(at)hub(dot)org
<pgsql-hackers(at)hub(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026