Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

storage size of "bitstring"?


  • From: Alex Mayrhofer <axelm(at)nona(dot)net>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: storage size of "bitstring"?
  • Date: Sun, 22 Oct 2006 18:24:43 +0200
  • Message-id: <453B9B4B(dot)20001(at)nona(dot)net>

Hi,

Two short questions:

1) What storage size does the "bit(n)" data type have? Is it one byte per 8
bits (plus a "length" byte)? I didn't find this in neither the docs nor the
list archives ...

2) Additionally, how much storage space does a functional index which
returns "boolean" approx. take? Will it be a bitmap?

Reason: i need to add some flags to a row, and i don't want to spend an
entire byte per flag on a "boolean" column (even worse, new flags could
probably be added in the future) - would it make sense to use
a bitstring, together with a functional index on any "interesting" bit in
that case?

thanks,

Alex



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group