Re: [GENERAL] Real vs Float & 32bit vs 64bit CPU Performance Question

2005-07-31 Thread Alex Stapleton
Depending on how your version of PG was built, there will probably be hardly any difference in speed as far as the CPU is concerned as the FPU should be happy with both, and I think MMX/MMX2/SSE/SSE2/3dNow! have some relevant optimisations for that sort of thing as well. You will be transfe

[GENERAL] Real vs Float & 32bit vs 64bit CPU Performance Question

2005-07-28 Thread jbduffy
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 typ