Re: ONE MORE PERFORMANCE ISSUE WITH POSTGRES
От | Shridhar Daithankar |
---|---|
Тема | Re: ONE MORE PERFORMANCE ISSUE WITH POSTGRES |
Дата | |
Msg-id | 3DBEE26F.22205.535076E@localhost обсуждение исходный текст |
Ответ на | ONE MORE PERFORMANCE ISSUE WITH POSTGRES (Savita <savita@india.hp.com>) |
Список | pgsql-general |
On 29 Oct 2002 at 16:42, Savita wrote: > I just wanted to know is it possible to improve the performance of a query if > the query is calling any stored procedure in it. Generally if you are making 3-4 calls for select/update/insert, a stored procedure works much better compared to separate calls to database because communication overhead is only once and database probably pre-parse-pre-plan the queries in it. So yes, it does improve performance.. > Because when I run this query it takes 100% CPU usage and other applications are > hanging. What's the query? Could you elaborate more on that? And other applications are hanging is rediculous behaviour unless it's windows. On linux, any 100% CPU chewing task should not block any other task. At least 2.4.19 onwards, same goes for other unices.. Windows is a different story.(My mail client, pegasus maxes out CPU, if it can not reach SMTP host for some reason. This is XP/SP1.. Go figure) Bye Shridhar -- Dijkstra probably hates me(Linus Torvalds, in kernel/sched.c)
В списке pgsql-general по дате отправления: