Re: Memory usage per session - Mailing list pgsql-general

From AMatveev@bitec.ru
Subject Re: Memory usage per session
Date
Msg-id 3210185028.20160708184914@bitec.ru
Whole thread Raw
In response to Re: Memory usage per session  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Memory usage per session  (Melvin Davidson <melvin6925@gmail.com>)
Re: Memory usage per session  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
<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> 

pgsql-general by date:

Previous
From: AMatveev@bitec.ru
Date:
Subject: Re: Memory usage per session
Next
From: Melvin Davidson
Date:
Subject: Re: Memory usage per session