Re: specifics about BIT(n) types

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: specifics about BIT(n) types
Дата
Msg-id 200404131701.16844.peter_e@gmx.net
обсуждение исходный текст
Ответ на specifics about BIT(n) types  (Dennis Gearon <gearond@fireserve.net>)
Список pgsql-general
Dennis Gearon wrote:
> 1/ Are the bits in BIT(n) types stored as 1 bit per '0/1' or as one
> BYTE per '0/1' ?

1 bit

> 2/ What is the RANGE of the number of bits storable?

1 to about 8*10^9 should be possible (although perhaps not thoroughly
tested by many people)

> 3/ What kind of speed comparisons are there between using BIT(n)
> tyeps and using multiple columns of INT4/8 values?

There should not be any noticeable difference.


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: verifying unicode locale support
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: verifying unicode locale support