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 по дате отправления:

Предыдущее
От: Peter Galbavy
Дата:
Сообщение: Re: [HACKERS] mirroring problem (www.postgresql.org)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: UnixWare