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/
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 |