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