On 7/10/07, Евгений Кононов <kononov@xxxxxxxxxxxxx> wrote:
Здравствуйте, Andrej.
Privet ;) ... not that I speak any Russian, really.
ARB> What OS are you using, and what's hyper-trading? Hyper threading ARB> by any chance? That's the OSes responsibility, not the databases.
I'm use Fedora Core 5, based on two Intel(R) Xeon(TM) MP CPU 3.16GHz processors with Hyper-Trading technology. It means, that I use 4 virtual processors. And, then I run postgreSQL, he use only one processor and work very easy. I want to use postgreSQL on all my processors, but I don't know how did it.
As I said ... if the OS supports those hyperthreaded CPUs properly (I assume you're seing four CPUs in /proc/cpuinfo?) and you fire up concurrent connections to the database the OS should start spreading the load across CPUs. It's not the databases task (or capability) to make that decision.
Thank's !
Cheers, Andrej