public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vladimir Churyukin <[email protected]>
To: pghackers <[email protected]>
Subject: Multiple startup messages over the same connection
Date: Mon, 22 Jan 2024 11:58:36 -0800
Message-ID: <CAFSGpE2RxR51HXezRwO+vJ4MPHORTTc3djEkJztGkWON4cWP0g@mail.gmail.com> (raw)

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

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]
  Subject: Re: Multiple startup messages over the same connection
  In-Reply-To: <CAFSGpE2RxR51HXezRwO+vJ4MPHORTTc3djEkJztGkWON4cWP0g@mail.gmail.com>

* 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