On Tue, 19 Oct 2004 22:23:24 -0700, Josh Berkus <[EMAIL PROTECTED]> wrote:
> There have been issues with Postgres+HT, especially on Linux 2.4. Try
> turning HT off if other tuning doesn't solve things.
>
> Otherwise, see:
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
How would I turn that off? In the kernel config? Not too familiar with
that. I have a 2 proc xeon with 4 gigs of mem on the way for postgres,
so I hope HT isn't a problem. If HT is turned off, does it just not
use the other "half" of the processor? Or does the processor just work
as one unit?
Also, I'm taking a look at that site right now :)
-Josh
---------------------------(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
