Re: [PERFORM] Usage up to 50% CPU

2007-04-28 Thread Andres Retzlaff
On Fri, Apr 27, 2007 at 07:23:41PM +0930, Shane Ambler wrote: I would think that as you are sitting and watching the cpu usage, your query would seem to taking a while to run, leading me to wonder if you are getting a full table scan that is causing pg to wait for disk response? If so, you pro

Re: [PERFORM] Usage up to 50% CPU

2007-04-27 Thread Andres Retzlaff
Hi Magnus, in this case each CPU goes up to 50%, giveing me 50% total usage. I was specting as you say 1 query 100% cpu. Any ideas? Andrew On Fri, Apr 27, 2007 at 04:43:06AM +, Andres Retzlaff wrote: > Hi, > > I have pg 8.1.4 running in > Windows XP Pro > wirh a Pent

[PERFORM] Usage up to 50% CPU

2007-04-26 Thread Andres Retzlaff
Hi, I have pg 8.1.4 running in Windows XP Pro wirh a Pentium D and I notice that I can not use more than 50% of the cpus (Pentium D has 2 cpus), how can I change the settings to use the 100% of it. Regards, Andrew Retzlaff _ Adv