Re: specifics about BIT(n) types - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: specifics about BIT(n) types
Date
Msg-id 200404131701.16844.peter_e@gmx.net
Whole thread Raw
In response to specifics about BIT(n) types  (Dennis Gearon <gearond@fireserve.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: verifying unicode locale support
Next
From: Peter Eisentraut
Date:
Subject: Re: verifying unicode locale support