Real vs Float & 32bit vs 64bit CPU Performance Question

From: jbduffy(at)tiscali(dot)co(dot)uk
To: pgsql-general(at)postgresql(dot)org
Subject: Real vs Float & 32bit vs 64bit CPU Performance Question
Date: 2005-07-27 22:08:48
Message-ID: 42AE99790010326A@mk-cpfrontend-1.mail.uk.tiscali.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2005-07-27 22:17:00 Re: GUID for postgreSQL
Previous Message Dann Corbit 2005-07-27 21:45:48 Re: GUID for postgreSQL