Обсуждение: Any problem with the Long Integer type?

Поиск
Список
Период
Сортировка

Any problem with the Long Integer type?

От
wei725@lycos.com
Дата:
About four five years ago, I had received a few of emails about the data type problems on this mailing list. I believe
thatthe problem was about a performance issue. Is any problem withe the Long Integer type in the late releases? 

Thanks,

- w

Re: Any problem with the Long Integer type?

От
Pavel Stehule
Дата:
Hello

2010/6/26  <wei725@lycos.com>:
>
> About four five years ago, I had received a few of emails about the data type problems on this mailing list. I
believethat the problem was about a performance issue. Is any problem withe the Long Integer type in the late releases? 

There is no reason why Long can be slower. Maybe you are thinking
Numeric data type.

Regards

Pavel Stehule

>
> Thanks,
>
> - w
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: Any problem with the Long Integer type?

От
"Joshua D. Drake"
Дата:
On 6/26/2010 1:25 PM, Pavel Stehule wrote:
> Hello
>
> 2010/6/26<wei725@lycos.com>:
>
>> About four five years ago, I had received a few of emails about the data type problems on this mailing list. I
believethat the problem was about a performance issue. Is any problem withe the Long Integer type in the late releases? 
>>
> There is no reason why Long can be slower. Maybe you are thinking
> Numeric data type.
>

Actually as I understand it, if they are running 32bit it is
theorectically slower.

JD


Re: Any problem with the Long Integer type?

От
Pavel Stehule
Дата:
2010/6/27 Joshua D. Drake <jdrake@postgresql.org>:
> On 6/26/2010 1:25 PM, Pavel Stehule wrote:
>>
>> Hello
>>
>> 2010/6/26<wei725@lycos.com>:
>>
>>>
>>> About four five years ago, I had received a few of emails about the data
>>> type problems on this mailing list. I believe that the problem was about a
>>> performance issue. Is any problem withe the Long Integer type in the late
>>> releases?
>>>
>>
>> There is no reason why Long can be slower. Maybe you are thinking
>> Numeric data type.
>>
>
> Actually as I understand it, if they are running 32bit it is theorectically
> slower.

aha - I undestand now. It could be - but from 8.3 the overhead is
relative small.

Regards

Pavel Stehule

>
> JD
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>