Re: Memory usage per session

<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
tohave big catalog and long living sessions. <br /><br /> >What do you do exactly?<br /><br /> I've generate test
codethat  emulates instruction tree size for our production code.<br /> This test shows:<br /> -What is the size of
instructiontree for our typical  BP  <br />   it's greater than 300M for each session <br /> -How often do PostgreSql
parsethe 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 /></span>