William Yu wrote:
> On other note -- if you are thinking about SMP Opteron, you may
> actually get better performance from 1x275 (Dual Core 2.2ghz) versus
> 2x248 (2.2ghz). Full duals have twice the bandwidth but without good
> NUMA support, memory has to be interleaved between CPUs.
I thought the 2.6 kernel had good NUMA support? (I realize I just made
an assumption that the original poster was running PG on Linux 2.6.)
--
Guy Rouillier
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
