<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>
<br>
>> Oracle: about 5M<br>
>> postgreSql: about 160М<br>
<br>
<br>
<br>
>The almost session memory is used for catalog caches. So you should to have big catalog and long living sessions. <br>
<br>
>What do you do exactly?<br>
<br>
I've generate test code that emulates instruction tree size for our production code.<br>
This test shows:<br>
-What is the size of instruction tree for our typical BP <br>
it's greater than 300M for each session <br>
-How often do PostgreSql parse the text <br>
When postgres clean cache, so much often <br>
<br>
So Oracle is much better in this case. <br>
It's very difficult really estimate in such case, to buy Oracle or to by hardware.<br>
<br>
</body></html>