Search Postgresql Archives

Re: specifics about BIT(n) types

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux