Re: Memory usage per session
| От | Pavel Stehule |
|---|---|
| Тема | Re: Memory usage per session |
| Дата | |
| Msg-id | CAFj8pRDq2LTHmpcw8XipATjBE1NPbBSvxSJ4=uqNAR=kjY5_8Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Memory usage per session (AMatveev@bitec.ru) |
| Ответы |
Re: Memory usage per session
|
| Список | pgsql-general |
Hi
2016-07-08 15:16 GMT+02:00 <AMatveev@bitec.ru>:
Hi
> On 08/07/2016 14:11, AMatveev@bitec.ru wrote:
>> Hi.
>> The test performs about 11K lines of code
>> Memory usage per session:
>> Oracle: about 5M
>> MSSqlServer: about 4M
>> postgreSql: about 160М
> Visual C???
> You will have to run PostgreSQL on a proper Unix system to test for performance.
Of cause we understand that unix is faster( damn fork :)))
Our Current problem is memory:
(160m vs 5M) * 100 sessions = 16G vs 0.5G
We just can get "out of memory".
:(((
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?
Regards
Pavel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: