any plan to support shared servers like Oracle in PG?
currently there is one process per connection and it will not not very good
for some short time connection. In oracle database, it support shared
server which can serve more than 1 users at the same time.
See
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11166
do we have any plan about this?
There already are solutions regarding this feature in Postgres
using "connection pooler" wording
see
pgpool: http://www.pgpool.net/mediawiki/index.php/Main_Page
pgbouncer: https://pgbouncer.github.io/
there are also discussions to include this as a core feature
/messages/by-id/4b971a8f-ff61-40eb-8f30-7b57eb0fdf9d@postgrespro.ru
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
thank you for this information! takes 2 days to read the discussion..
On Wed, Mar 6, 2019 at 3:13 AM legrand legrand <legrand_legrand@hotmail.com>
wrote:
Show quoted text
There already are solutions regarding this feature in Postgres
using "connection pooler" wordingsee
pgpool: http://www.pgpool.net/mediawiki/index.php/Main_Page
pgbouncer: https://pgbouncer.github.io/
there are also discussions to include this as a core feature
/messages/by-id/4b971a8f-ff61-40eb-8f30-7b57eb0fdf9d@postgrespro.ru
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html