Yeb Havinga <yebhavi...@gmail.com> writes:
> Just reading up on this interesting thread. WFIW, 2 years ago I and a 
> collegue of mine did a hardware comparison of early Intel and AMD 
> desktop quadcore processors to run postgres database, with most other 
> parts comparable. The intel processor was 20 to 30 % faster in cpu 
> operations to the (first generation) Phenom at almost everything, except 
> at index creation. The test that the AMD finished in a few minutes, we 
> had to stop on the Intel because it simply didn't finish. We double 
> checked configuration settings and could not find explainable 
> differences. I hesitate to post this information here, because its hard 
> to believe that an actual big difference between the processors exists, 
> and it more likely was something in our test setup. Still: the 
> difference was *only* in index creation, which is kindoff like a qsort yes?

Interesting.  Yes, btree index creation is essentially a sort ...

                        regards, tom lane

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

Reply via email to