Re: size of bytea + performance issues

Поиск
Список
Период
Сортировка
От Jochen Schlosser
Тема Re: size of bytea + performance issues
Дата
Msg-id c184313e0601311115j35f61f77o9452c69381f8b103@mail.gmail.com
обсуждение исходный текст
Ответ на Re: size of bytea + performance issues  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: size of bytea + performance issues  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
> Well, it's in the FAQ under "How much database disk space is required
> to store data from a typical text file?" but the per tuple overhead is
> between 36 and 44 bytes. depends a bit on the version.

allright... thx a lot!
I did not see this point in the FAQ because I am not storing data from
a textfile and did not look in that direction... What store is
basically a encoding scheme of several hash bins which store
distances. Thus it is just a bitvector and to the best of my knowledge
a bytea or  varyiing bitarray is the most space efficient method to
store my information(???).

Thanks again,

Tschak

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: size of bytea + performance issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Basic questions about PQprepare()