tables > 1 gig - Mailing list pgsql-hackers

From Bruce Momjian
Subject tables > 1 gig
Date
Msg-id 199906171429.KAA21749@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] tables > 1 gig
List pgsql-hackers
Config.h has this.  Does this need to be updated because we can't vacuum
multi-segment relations?  I have changed it to 7F000000:

/** RELSEG_SIZE is the maximum number of blocks allowed in one disk file.* Thus, the maximum size of a single file is
RELSEG_SIZE* BLCKSZ;* relations bigger than that are divided into multiple files.** CAUTION: RELSEG_SIZE * BLCKSZ must
beless than your OS' limit on file* size.  This is typically 2Gb or 4Gb in a 32-bit operating system.  By* default, we
makethe limit 1Gb to avoid any possible integer-overflow* problems within the OS.  A limit smaller than necessary only
meanswe* divide a large relation into more chunks than necessary, so it seems* best to err in the direction of a small
limit. (Besides, a power-of-2* value saves a few cycles in md.c.)** CAUTION: you had best do an initdb if you change
eitherBLCKSZ or* RELSEG_SIZE.*/
 
#define RELSEG_SIZE (0x40000000 / BLCKSZ)


--  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 Galbavy
Date:
Subject: Re: [HACKERS] mirroring problem (www.postgresql.org)
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: UnixWare