Re: - Mailing list pgsql-performance

From PFC
Subject Re:
Date
Msg-id op.stjnvwapth1vuj@localhost
Whole thread Raw
In response to  (Jean-Max Reymond <jmreymond@gmail.com>)
List pgsql-performance
> So, it seems that for my application (database in memory, 14 millions
> of very small requests), Centrino (aka Pentium M) has a build-in
> hardware to boost Postgres performance :-)
> Any experience to confirm this fact ?

    On my Centrino, Python flies. This might be due to the very large
processor cache. Probably it is the same for perl. With two megabytes of
cache, sorting things that fit into the cache should be a lot faster too.
Maybe this explains it.

    Check this out :

http://www.anandtech.com/linux/showdoc.aspx?i=2308&p=5

http://www.anandtech.com/cpuchipsets/showdoc.aspx?i=2129&p=11

    Bonus for Opteron lovers :

"The Dual Opteron 252's lead by 19% over the Quad Xeon 3.6 GHz 667MHz FSB"

http://www.anandtech.com/cpuchipsets/showdoc.aspx?i=2397&p=12

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: How to speed up delete
Next
From: Madison Kelly
Date:
Subject: Need suggestion high-level suggestion on how to solve a performance problem