On 19.01.2018 20:01, Pavel Stehule wrote:
If we will have separate scheduling bgworker(s) as Tomas proposed, then in any case we will have to do some kind of redirection.
It can be done in more efficient way than using Unix sockets (as it is in case of locally installed pgbouncer), but even if we use shared memory queue then
performance will be comparable and limited by number of context switches. It is possible to increase it by combining several requests into one parcel.
But it even more complicate communication protocol between clients, scheduling proxies and executors.
--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company