Multiple startup messages over the same connection - Mailing list pgsql-hackers

From Vladimir Churyukin
Subject Multiple startup messages over the same connection
Date
Msg-id CAFSGpE2RxR51HXezRwO+vJ4MPHORTTc3djEkJztGkWON4cWP0g@mail.gmail.com
Whole thread Raw
Responses Re: Multiple startup messages over the same connection
List pgsql-hackers
Hello,

A question about protocol design - would it be possible to extend the protocol, so it can handle multiple startup / authentication messages over a single connection? Are there any serious obstacles? (possible issues with re-initialization of backends, I guess?)
If that is possible, it could improve one important edge case - where you have to talk to multiple databases on a single host currently, you need to open a separate connection to each of them. In some cases (multitenancy for example), you may have thousands of databases on a host, which leads to inefficient connection utilization on clients (on the db side too). A lot of other RDBMSes  don't have this limitation.

thank you,
-Vladimir Churyukin

pgsql-hackers by date:

Previous
From: Christoph Berg
Date:
Subject: Re: psql: Allow editing query results with \gedit
Next
From: "Tristan Partin"
Date:
Subject: Re: make dist using git archive