tables > 1 gig
От | Bruce Momjian |
---|---|
Тема | tables > 1 gig |
Дата | |
Msg-id | 199906171429.KAA21749@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: [HACKERS] tables > 1 gig
|
Список | 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 по дате отправления: