Re: Why is it not using the other processor?

Linh Luong writes:

> My postgres is running on a dual processor.  But when I run a query and
> look at TOP and notice only one processor is being used.  And it is
> being used 100% (assuming only 1 process is active).  Why would it
> allocate the work to the other processor.

Ask your operating system provider.  PostgreSQL just allocates processes,
it doesn't decide on what CPU they'll run.

> One more question. I am using the browser to display my data.  If I
> start the query by means of pressing the Search button and then I decide
> to stop the search by pressing STOP (on the broswer).  The browser stop
> executing and I can still surf the web.  My question is why is the
> process that handles the search still running when I view TOP.

You are probably using PHP with persistent connections.  They could stay
open indefinitely.  You might have to kill the postgres process or the web
server manually.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter