Mark Wong wrote:
Hi everyone,
For those of you watching the the daily results generated from STP
(http://developer.osdl.org/markw/postgrescvs/dbt2/) I have callgraph
data from oprofile collected starting from the Sept 9 results. Here is
an example of what it looks like:
http://www.testing.osdl.org/stp/303184/results/0/callgraph.txt
I hope it's useful.
Rather unrelated, but the tests here use the standard settings for
wal_buffers. As I have read on this list, 8.1 needs a much higher setting
for wal_buffers for good performance (128 or 256?). I don't know if you want
to change this setting because it will make the results incomparable, but it
should improve overall performance.
See
http://archives.postgresql.org/pgsql-hackers/2005-07/msg01004.php
Best Regards,
Michael Paesold
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match