Re: [GENERAL] Querry and SMP mechine

2005-08-07 Thread Martijn van Oosterhout
On Sun, Aug 07, 2005 at 02:15:50PM +0300, Michael Ben-Nes wrote: > >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 cp

Re: [GENERAL] Querry and SMP mechine

2005-08-07 Thread Michael Ben-Nes
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 th

Re: [GENERAL] Querry and SMP mechine

2005-08-07 Thread Magnus Hagander
> 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 ? Yes, that is normal.

[GENERAL] Querry and SMP mechine

2005-08-07 Thread Michael Ben-Nes
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 ? Thanks -- ---

Re: [GENERAL] Querry and SMP mechine

2005-08-07 Thread Martijn van Oosterhout
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.