"tschak" <jochen.schlosser@xxxxxxxxx> writes: > Can I explicitly store 4 Bit (FIXED lenght) in a column without > "wasting" space? No. There is no provision in Postgres for data types occupying less than a byte. You'll need to think about merging those columns together. > Alright... so I do not need the OIDs! But as for as I know I need OIDs > if I want to use a BLOB for the complete information, which I would > like to do once again to reduce the size of each row in the table (from > 80 *4 Bits down to just 1 Pointer to the BLOB). You are confusing OIDs with BLOBs ... they are not the same thing. There are a couple different ways of handling BLOBs in Postgres: bytea values and "large objects". For the most part I'd suggest bytea, though if you need cheap access to sub-sections of a BLOB, large objects would be the way to go. regards, tom lane
