<html><head><title>Re: [GENERAL] Memory usage per session</title>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<body>
<span style=" font-family:'courier new'; font-size: 9pt;">Hi<br>
<br>
>> >> The test performs about 11K lines of code<br>
>> >> Oracle: about 5M<br>
>> >> postgreSql: about 160М<br>
<br>
<br>
>What is the actual O/S that PostgreSQL is installed on? <br>
>How much total memory is on the server? <br>
>I would be very curious about the values you have specified in postgresql.conf?<br>
> Also, what is the exact version of PostgreSQL you are using?<br>
>What is the total time to complete the test for all 3 DB's?<br>
>The best I can tell is that with all the unknowns, you are comparing apples to oranges.<br>
<br>
There is real problem for us.<br>
<span style=" font-family:'verdana';">The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree the first time the function is called (within each session)<span style=" font-family:'times new roman'; font-size: 14pt;"> <br>
<br>
<span style=" font-family:'Courier New'; font-size: 9pt;">The size of this instruction tree depends only of postgreSql build.<br>
<br>
And size is big, and size is not share between session.<br>
<br>
I understand that nobody says: Damn One second I will implement it soon :)<br>
<br>
Thank all for constructive answers.</body></html>