Re: Why is it not using the other processor?
От | Peter Eisentraut |
---|---|
Тема | Re: Why is it not using the other processor? |
Дата | |
Msg-id | Pine.LNX.4.30.0107051757130.677-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Why is it not using the other processor? (Linh Luong <linh.luong@computalog.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: