Re: Cache invalidation after authentication (on-the-fly rolecreation) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Cache invalidation after authentication (on-the-fly rolecreation)
Date
Msg-id 20180704001032.pgojokf5qwhyxmzj@alap3.anarazel.de
Whole thread Raw
In response to Re: Cache invalidation after authentication (on-the-fly rolecreation)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Cache invalidation after authentication (on-the-fly role creation)  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
Hi,

On 2018-07-03 19:44:21 -0400, Alvaro Herrera wrote:
> On 2018-Jul-04, Thomas Munro wrote:
> 
> > Hello hackers,
> > 
> > I'd like to do this to postinit.c:
> > 
> >                 PerformAuthentication(MyProcPort);
> > +               AcceptInvalidationMessages();
> >                 InitializeSessionUserId(username, useroid);
> > 
> > Any objections?
> 
> Is there a measurable performance overhead to this change?

I can't see it being relevant here. We accept inval message in plenty
other places, and in comparison to session startup it should be just
about inmeasurable.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PATCH: pgbench - option to build using ppoll() for largerconnection counts
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: How can we submit code patches that implement our (pending) patents?