| From: | "Rakesh Kumar" <rakeshkumar464(at)mail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Caching of sproc |
| Date: | 2017-12-20 17:09:56 |
| Message-ID: | trinity-270ffe6a-eaa4-4e9b-9c65-c2ca29646d9b-1513789796650@3c-app-mailcom-lxa01 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I want to confirm my understanding. When a stored procedure is called the first time the code's compiled version is cached and used next time it is executed. However it is cached once for every session and not globally for all sessions. In other words, if we have a large number of concurrent sessions (x num of sessions) executing the same procedures (y num of procedures), the memory pressure will be
x * y.
The reason why I am asking this is that the application we are moving from Oracle is heavy on stored procedures with some packages running into 8000-10000 lines of code.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2017-12-20 17:11:29 | Re: postgresql 9.5 has ocuuered OOM |
| Previous Message | Uwe | 2017-12-20 17:01:40 | Re: postgresql 9.5 has ocuuered OOM |