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.
--
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 |