Re: this is what i meant
От | Tom Lane |
---|---|
Тема | Re: this is what i meant |
Дата | |
Msg-id | 24433.1137474334@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | this is what i meant ("tschak" <jochen.schlosser@gmail.com>) |
Список | pgsql-general |
"tschak" <jochen.schlosser@gmail.com> 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
В списке pgsql-general по дате отправления: