Re: [HACKERS] Problems with >2GB tables on Linux 2.0

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Дата
Msg-id 199902081516.KAA14338@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Problems with >2GB tables on Linux 2.0  (Peter T Mount <peter@retep.org.uk>)
Ответы Re: [HACKERS] Problems with >2GB tables on Linux 2.0  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-hackers
> Not sure. My original choice was to subtract 1 from the calculated
> maximum, which meant it would split just before the 2Gb limit.
> 
> However, running with the value set at the lower value:
> 
>  1998585856 Feb  8 02:25 /opt/db/base/test/smallcat
>   599007232 Feb  8 03:21 /opt/db/base/test/smallcat.1
> 
> Total 26653000 rows loaded
> 
> Would anyone really notice the lower value?
> 
> Perhaps we could make this another compile time setting, like the block
> size?

I guess all I am saying is I prefer the max-1 value.  Seems more
logical.  Could be set in config.h.in, though.

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

Предыдущее
От: Nick Bastin
Дата:
Сообщение: Re: Commercial support, was Re: [HACKERS] v6.4.3 ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] trouble with rules