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 по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Create/Erase 5000 Tables in PostGRE SQL in execution
Следующее
От: "R, Rajesh (STSD)"
Дата:
Сообщение: Re: [PATCH] Better way to check for getaddrinfo function.