Real vs Float & 32bit vs 64bit CPU Performance Question - Mailing list pgsql-general

From jbduffy@tiscali.co.uk
Subject Real vs Float & 32bit vs 64bit CPU Performance Question
Date
Msg-id 42AE99790010326A@mk-cpfrontend-1.mail.uk.tiscali.com
Whole thread Raw
Responses Re: Real vs Float & 32bit vs 64bit CPU Performance Question
List pgsql-general
Hi

I am wrting a application that involves a lot of floating point number crunching.
My data is stored in tables of the form:

TABLE data (
date_id  INT,
value FLOAT)

I have just noticed in the documention that the FLOAT data type is stored
in 8 bytes (ie 64 bits) as opposed to the REAL data type which uses 4 bytes
(ie 32 bits).

All things being equal, does this mean that if I change my data type to REAL
(and lose some precision) I will see a significant performance increase on
my 32 bit Pentium 4?

Or, if I keep my data type as FLOAT will I see a significant performance
increase by changing to a 64 bit CPU?

Regards

John Duffy




___________________________________________________________

Book yourself something to look forward to in 2005.
Cheap flights - http://www.tiscali.co.uk/travel/flights/
Bargain holidays - http://www.tiscali.co.uk/travel/holidays/



pgsql-general by date:

Previous
From: "DracKewl"
Date:
Subject: Re: Cursor Issue??
Next
From: Mark Mikulec
Date:
Subject: Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues?