Re: specifics about BIT(n) types

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Dennis Gearon <gearond(at)fireserve(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: specifics about BIT(n) types
Date: 2004-04-13 15:01:16
Message-ID: 200404131701.16844.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-13 15:02:46 Re: verifying unicode locale support
Previous Message Tom Lane 2004-04-13 14:36:05 Re: verifying unicode locale support