Martijn van Oosterhout wrote:
On Sun, Aug 07, 2005 at 01:04:51PM +0300, Michael Ben-Nes wrote:
Hello
Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT.
doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ).
I noticed that when im runing a big query only one of the CPUs become
loaded.
Is it normal behavior ? am i missing something ?
Yep, PostgreSQL uses a single backend for each client, so if you want
to use all four processors, you need to be running four queries
simultaneously...
You mean select 1, select 2 & sleect 3 will run on the same cpu becouse
they submited from the same PSQL session ?
Or each select will be run in turn on the most idle cpu ?
Is this true for all the other OS or just for Linux ? (Bsd, solaris... )
Thanks
Have a nice day,
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
