Tom Lane wrote:
Gaetano Mendola <[EMAIL PROTECTED]> writes:
I proposed weeks ago to see how the CSStorm is affected by stick each
backend in one processor ( where the process was born ) using the
cpu-affinity capability ( kernel 2.6 ), is this proposal completely
out of mind ?
That was investigated long ago. See for instance
http://archives.postgresql.org/pgsql-performance/2004-04/msg00313.php
If I read correctly this help on the CSStorm, I guess also that this could
also help the performances. Unfortunatelly I do not have any kernel 2.6 running
on SMP to give it a try.
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend