Title: Re: [GENERAL] Memory usage per session
Hi
>> Oracle: about 5M
>> postgreSql: about 160М
>The almost session memory is used for catalog caches. So you should to have big catalog and long living sessions.
>What do you do exactly?
I've generate test code that emulates instruction tree size for our production code.
This test shows:
-What is the size of instruction tree for our typical BP
it's greater than 300M for each session
-How often do PostgreSql parse the text
When postgres clean cache, so much often
So Oracle is much better in this case.
It's very difficult really estimate in such case, to buy Oracle or to by hardware.
- [GENERAL] Memory usage per session AMatveev
- Re: [GENERAL] Memory usage per session Achilleas Mantzios
- Re: [GENERAL] Memory usage per session AMatveev
- Re: [GENERAL] Memory usage per session Pavel Stehule
- Re: [GENERAL] Memory usage per session AMatveev
- Re: [GENERAL] Memory usage per se... Melvin Davidson
- Re: [GENERAL] Memory usage pe... John McKown
- Re: [GENERAL] Memory usag... Karl Czajkowski
- Re: [GENERAL] Memory usag... John R Pierce
- Re: [GENERAL] Memory usag... AMatveev
- Re: [GENERAL] Memory usag... AMatveev
- Re: [GENERAL] Memory usage per se... Pavel Stehule
- Re: [GENERAL] Memory usage per session John McKown
- Re: [GENERAL] Memory usage per session Stephen Frost