Re: decimal(5) vs int8. Which more efficient.

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: decimal(5) vs int8. Which more efficient.
Дата
Msg-id 3C8986F1.C5DC18FB@fourpalms.org
обсуждение исходный текст
Ответ на decimal(5) vs int8. Which more efficient.  (Francisco Reyes <lists@natserv.com>)
Ответы Re: decimal(5) vs int8. Which more efficient.  (Francisco Reyes <lists@natserv.com>)
Список pgsql-general
> What would be more efficient for storing a value that is 5 Bytes long?
> decimal(5) or int8?
> Does decimal(5) actually uses up only 5 bytes? Does that cause any
> problems?

int8 wins on all counts afaik. decimal() and numeric() store things as
quasi-BCD and is less dense than a true binary storage type.

                     - Thomas

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is vacuum full lock like old's vacuum's lock?
Следующее
От: "Arguile"
Дата:
Сообщение: Re: How to check for successfull inserts