Tom Lane wrote:
Richard Huxton <dev@archonet.com> writes:
Tom Lane wrote:
What's he using?
7.4.12 (.12 as of last week). I've seen context-switching peak at 80000
on a quad-Xeon that really shouldn't be straining.
Try 8.1.3.
Thanks. I'll see if we can run a parallel installation overnight or
something.
--
Richard Huxton
Archonet Ltd
---------------------------(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