Re: One process per session lack of sharing

Поиск
Список
Период
Сортировка
От AMatveev@bitec.ru
Тема Re: One process per session lack of sharing
Дата
Msg-id 301417900.20160712173911@bitec.ru
обсуждение исходный текст
Ответ на Re: One process per session lack of sharing  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi

> AMatveev@bitec.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.


-- 




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: One process per session lack of sharing
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <