Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2022-06-22 Thread Todd Hubers
Hi Everyone, Here is a progress update. I have an established team of 2 fulltime systems programmers who have been working on this area for a couple of months now. - Past - *Impersonation* - a prototype has been completed for Option-1 "Impersonation" - *Benchmarking* - has been

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2022-02-01 Thread Todd Hubers
Hi Everyone, Benchmarking work has commenced, and is ongoing. - *OPTIONS 5/6/7* - `SET SESSION AUTHORIZATION` takes double the time of a single separate SimpleQuery. This is to be expected, because double the amount of SimpleQuery messages are being sent, and that requires a full Simp

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2022-01-06 Thread Todd Hubers
Hi Everyone, I have started working on this: - Benchmarking - increasingly more comprehensive benchmarking - Prototyping - to simulate the change of users (toggling back and forth) - Draft Implementation - of OPTION-1 (New Protocol Message) - (Then: Working with Odyssey and PgBouncer

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-23 Thread Todd Hubers
Hi Jacob and Daniel, Thanks for your feedback. >@Daniel - I think thats conflating session_user and current_user, SET ROLE is not a login event. This is by design and discussed in the documentation.. Agreed, I am using those terms loosely. I have updated option 4 in the proposal document. I have

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-22 Thread Jacob Champion
On Sat, 2021-11-20 at 16:16 -0500, Tom Lane wrote: > One more point is that the proposed business about > > * ImpersonateDatabaseUser will either succeed silently (0-RTT), or > fail. Upon failure, no further commands will be processed until > ImpersonateDatabaseUser succeeds. > > seems to re

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-22 Thread Daniel Gustafsson
> On 21 Nov 2021, at 03:05, Todd Hubers wrote: > 10) Tom said: "How would this interact with the "on login" triggers that > people keep asking for? > > That's a good point. I would imagine that SET ROLE (which is currently > unsuitable) would have the same requirement. The answer is Shared Fun

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-20 Thread Todd Hubers
Hi Tom, Justin, and Andrey, Thanks everybody for your feedback so far! I agree, there are a few unknowns for the design and impact and there are many details to iron out. *Benchmarking* - Overall I think it's best to explore improvements with benchmarking. The key goal of this proposal pertains t

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-20 Thread Tom Lane
Justin Pryzby writes: > On Sun, Nov 21, 2021 at 03:11:03AM +1100, Todd Hubers wrote: >> - Google Document with Commenting turned on >> https://docs.google.com/document/d/1u6mVKEHfKtR80UrMLNYrp5D6cCSW1_arcTaZ9HcAKlw/edit?usp=sharing. > You proposed a PQ protocol version of SET ROLE/SET SESSION aut

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-20 Thread Justin Pryzby
On Sun, Nov 21, 2021 at 03:11:03AM +1100, Todd Hubers wrote: > I have just joined to start a community consultation process for a > proposal. I just finished the proposal document, I spent time writing a > Problem and Solution section, and I have done quite a bit of upfront > exploration of the cod

Re: Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-20 Thread Andrey Borodin
Hi Todd! > I have just joined to start a community consultation process for a proposal. > I just finished the proposal document, I spent time writing a Problem and > Solution section, and I have done quite a bit of upfront exploration of the > code. > > See: > > * Google Document with Comment

Feature Proposal: Connection Pool Optimization - Change the Connection User

2021-11-20 Thread Todd Hubers
Hi, I have just joined to start a community consultation process for a proposal. I just finished the proposal document, I spent time writing a Problem and Solution section, and I have done quite a bit of upfront exploration of the code. See: - Google Document with Commenting turned on htt