Postgres Pro
Downloads
Home   >   mailing lists

Re: One process per session lack of sharing - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: One process per session lack of sharing
Date
Msg-id CANP8+jLqVRY9Ls=0gruEAzdZ_SiLTJhM2D9kWyxbUKwfuNSuMw@mail.gmail.com
Whole thread Raw
In response to One process per session lack of sharing  (AMatveev@bitec.ru)
Responses Re: One process per session lack of sharing  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
Tree view
On 12 July 2016 at 09:57, <AMatveev@bitec.ru> wrote:
 
We have faced with some lack of sharing resources.
So in our test memory usage per session:
Oracle: about 5M
MSSqlServer: about 4M
postgreSql: about 160М

Using shared resources also has significant problems, so care must be taken.

I think its clear that threading is out, but it is far from being the only solution to reducing the memory overhead of sharing.

Analysing the overhead and suggesting practical ways forward may help.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: One process per session lack of sharing
Next
From: Peter Eisentraut
Date:
Subject: Re: sslmode=require fallback