Re: int8 version of NUMERIC?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: int8 version of NUMERIC?
Дата
Msg-id 20040112152816.GA21007@wolff.to
обсуждение исходный текст
Ответ на Re: int8 version of NUMERIC?  (David Garamond <lists@zara.6.isreserved.com>)
Ответы Re: int8 version of NUMERIC?  (Adam Witney <awitney@sghms.ac.uk>)
Список pgsql-general
On Sun, Jan 11, 2004 at 21:53:09 +0700,
  David Garamond <lists@zara.6.isreserved.com> wrote:
>
> My concern is that, the PostgreSQL docs says NUMERIC & DECIMAL is very
> slow compared to INT/BIGINT. Should I worry about that?

Most likely disk IO not cpu will be your bottleneck and the extra overhead
of numeric relative to int or float won't be a big deal.

Numeric is stored usingh based 10000 (at least in 7.4.x) and hence isn't
that horrible performance-wise (as compared to say storing it as an ascii
string).

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

Предыдущее
От: joseph speigle
Дата:
Сообщение: Re: PostgreeSQL C header files
Следующее
От: David Garamond
Дата:
Сообщение: Re: Drawbacks of using BYTEA for PK?