Dirk,
> does anybody have expierence with this machine (4x 875 dual core Opteron
> CPUs)?
Nope. I suspect that you may be the first person to report in on
dual-cores. There may be special compile issues with dual-cores that
we've not yet encountered.
> We run RHEL 3.0, 32bit and under high load it is a drag. We
> mostly run memory demanding queries. Context switches are pretty much
> around 20.000 on the average, no cs spikes when we run many processes in
> parallel. Actually we only see two processes in running state! When
> there are only a few processes running context switches go much higher.
> At the moment we are much slower that with a 4way XEON box (DL580).
Um, that was a bit incoherent. Are you seeing a CS storm or aren't you?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(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
