Re: Efficient use of space in large table?

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: Efficient use of space in large table?
Дата
Msg-id Pine.NEB.4.44.0207081254150.476-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: Efficient use of space in large table?  (Manfred Koizar <mkoi-pg@aon.at>)
Ответы Re: Efficient use of space in large table?  (Alvaro Herrera <alvherre@atentus.com>)
Список pgsql-general
On Fri, 5 Jul 2002, Manfred Koizar wrote:

> first of all, text is ok.  You might want to store NULL instead of ''
> to squeeze out a few bytes here and there.

Correct me if I'm wrong, but doesn't NULL take up *more* room than ''?
After all, as soon as you have a NULL, you have to have a null bit array
in the tuple.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: database backup
Следующее
От: Bruce Momjian
Дата:
Сообщение: Error messages changes for 7.3?