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 probably wouldn't be seeing that much cpu usage... (if the cpu
is waiting for disk it's >idling)
Mike Stone
Yes, I notice 3 steeps:
1) the CPU is at 100% (of 1 cpu)
2) the HDD is 100% but no much of the cpu
3) I get the query display
I will see what can I do to improved the speed. At this moment is taking 10
sec to get the responce.
Regards,
Andrew Retzlaff
_________________________________________________________________
Advertisement: Its simple! Sell your car for just $30 at carsales.com.au
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801577%2Fpi%5F1005244%2Fai%5F838588&_t=754951090&_r=tig&_m=EXT
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
