Re: Number of connections - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Number of connections
Date
Msg-id 475D5E3C.9020802@postgresql.org
Whole thread Raw
In response to Re: Number of connections  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgadmin-hackers
Roberts, Jon wrote:
> I would think far less code would be needed if the tool could be configured
> to only use one connection.

How'd you figure that? You'd need to write the connection pooler, start
tracking connection states in far more detail than we do now, and
potentially have to start new connections (which is expensive) in
response to UI interactions which the user may well expect to be almost
instantaneous.

More importantly, I don't imagine you'd save much anyway - connections
are relatively cheap, and pgAdmin only creates them when you actually
need them (and closes them when you close Windows for which they were
created). I can't imagine such an architecture saving more than 1 in ten
connections at best.

Regards, Dave.

pgadmin-hackers by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: Number of connections
Next
From: "Roberts, Jon"
Date:
Subject: Re: Number of connections