Re: One process per session lack of sharing

From: AMatveev(at)bitec(dot)ru
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: One process per session lack of sharing
Date: 2016-07-12 14:39:11
Message-ID: 301417900.20160712173911@bitec.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

> AMatveev(at)bitec(dot)ru writes:
>> Is there any plan to implement "session per thread" or "shared
>> sessions between thread"?

> No, not really. The amount of overhead that would add --- eg, the need
> for locking on what used to be single-use caches --- makes the benefit
> highly questionable.
A two-layer cache is the best answer.
> Also, most people who need this find that sticking
> a connection pooler in front of the database solves their problem
It has some disadvantages. Lack of temporary table for example
Practical usage of that table with connection poller is highly
questionable.
And so on.
> , so
> there's not that much motivation to do a ton of work inside the database
> to solve it there.
It is clear. Thank you.

--

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2016-07-12 15:04:45 Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Previous Message Tom Lane 2016-07-12 14:18:54 Re: One process per session lack of sharing