Re: Performance problems with arithmetic operators

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Performance problems with arithmetic operators
Дата
Msg-id 3BA8A878.965A4839@fourpalms.org
обсуждение исходный текст
Ответ на Performance problems with arithmetic operators  (Mark Johnathan Greenaway <mark@commsecure.com.au>)
Список pgsql-general
> Has anyone else experienced serious performance problems when using arithmetic
> expressions in queries?
...
> a and b are numeric(10, 3)

numeric() is implemented with binary coded decimal representation, which
is substantially slower than direct processor supported math involving
just ints and floats. Try testing this with different types to see what
happens.

                       - Thomas

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance question (stripped down the problem)
Следующее
От: "Roderick A. Anderson"
Дата:
Сообщение: Re: read in to psql from file