Thread: 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.
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 https://www.postgresql.org/message-id/flat/4b971a8f-ff61-40eb-8f30-7b57eb0fdf9d%40postgrespro.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:
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
https://www.postgresql.org/message-id/flat/4b971a8f-ff61-40eb-8f30-7b57eb0fdf9d%40postgrespro.ru
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html