Any problem with the Long Integer type?

Started by Weialmost 16 years ago4 messagesgeneral
Jump to latest
#1Wei
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?

Thanks,

- w

#2Pavel Stehule
pavel.stehule@gmail.com
In reply to: Wei (#1)
Re: Any problem with the Long Integer type?

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.

Regards

Pavel Stehule

Show quoted text

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

#3Joshua D. Drake
jdrake@postgresql.org
In reply to: Pavel Stehule (#2)
Re: Any problem with the Long Integer type?

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.

JD

#4Pavel Stehule
pavel.stehule@gmail.com
In reply to: Joshua D. Drake (#3)
Re: Any problem with the Long Integer type?

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

Show quoted text

JD

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