Search Postgresql Archives

specifics about BIT(n) types

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

 



please CC me as I'm on silent or digest.
--------------------------------------------------
I know these questions have been asked, and once by me. I can't find it in the archives or in the documentation.


1/ Are the bits in BIT(n) types stored as 1 bit per '0/1' or as one BYTE per '0/1' ?
2/ What is the RANGE of the number of bits storable?
3/ What kind of speed comparisons are there between using BIT(n) tyeps and using multiple columns of INT4/8 values?


For example:

   SELECT bit_varying_128_A & bit_varying_128_B FROM some_table;
vs
   SELECT int8_A & int8_B & int8_C & int8_C FROM some_other_table;


I sure would love to see the answers to these questions put in the BIT(n) section of the USER MANUAL, section 5.9.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[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