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(at)gmx(dot)net http://funkturm.homeip.net/~peter