Re: performance results on IBM POWER7 - Mailing list pgsql-hackers

From Ants Aasma
Subject Re: performance results on IBM POWER7
Date
Msg-id CA+CSw_uuc1y23awTwqrBEh4yWhD4AE5Cu3bsUO=Yo+r8hzYj0A@mail.gmail.com
Whole thread Raw
In response to performance results on IBM POWER7  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: performance results on IBM POWER7  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Mar 1, 2012 at 4:54 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> ... After that I think maybe some testing of the
> remaining CommitFest patches might be in order (though personally I'd
> like to wrap this CommitFest up fairly soon) to see if any of those
> improve things.

Besides performance testing, could you check how clocksources behave
on this kind of machine?
You can find pg_test_timing tool attached here:
http://archives.postgresql.org/pgsql-hackers/2012-01/msg00937.php

To see which clocksources are available, you can do:
# cat /sys/devices/system/clocksource/clocksource0/available_clocksource
To switch the clocksource, just write the desired clocksource like this:
# echo hpet > /sys/devices/system/clocksource/clocksource0/current_clocksource

Thanks,
Ants Aasma


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Speed dblink using alternate libpq tuple storage
Next
From: "Jehan-Guillaume (ioguix) de Rorthais"
Date:
Subject: Allowing multi "-t" and adding "-n" to vacuumdb ?