Re: [HACKERS] "CANNOT EXTEND" - - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] "CANNOT EXTEND" -
Date
Msg-id 199903172323.SAA21180@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] "CANNOT EXTEND" -  (Peter T Mount <peter@retep.org.uk>)
List pgsql-hackers
> > 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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [HACKERS] "CANNOT EXTEND" -
Next
From: Clark Evans
Date:
Subject: OID vs SERIAL? (Was: Re: [HACKERS] Sequences....)