| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> |
| Cc: | postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Querry and SMP mechine |
| Date: | 2005-08-07 10:09:55 |
| Message-ID: | 20050807100954.GA8033@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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...
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-08-07 10:28:44 | Re: Querry and SMP mechine |
| Previous Message | Michael Ben-Nes | 2005-08-07 10:04:51 | Querry and SMP mechine |