public inbox for [email protected]  

help / color / mirror / Atom feed

From: Heikki Linnakangas <[email protected]>
To: Vladimir Churyukin <[email protected]>
To: pghackers <[email protected]>
Subject: Re: Multiple startup messages over the same connection
Date: Tue, 23 Jan 2024 09:43:50 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFSGpE2RxR51HXezRwO+vJ4MPHORTTc3djEkJztGkWON4cWP0g@mail.gmail.com>
References: <CAFSGpE2RxR51HXezRwO+vJ4MPHORTTc3djEkJztGkWON4cWP0g@mail.gmail.com>

On 22/01/2024 21:58, Vladimir Churyukin wrote:
> 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.

The protocol and the startup message are the least of your problems. 
Yeah, it would be nice if you could switch between databases, but the 
assumption that one backend operates on one database is pretty deeply 
ingrained in the code.

-- 
Heikki Linnakangas
Neon (https://neon.tech)

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Multiple startup messages over the same connection
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox