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

From Michael Paquier
Subject Re: Cache invalidation after authentication (on-the-fly rolecreation)
Date
Msg-id 20180704043523.GF1672@paquier.xyz
Whole thread Raw
In response to Re: Cache invalidation after authentication (on-the-fly role creation)  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
On Wed, Jul 04, 2018 at 04:25:18PM +1200, Thomas Munro wrote:
> Yeah, using "pgbench -c 8 -j 8 -T 60 --connect -S -M prepared
> postgres" I wasn't able to measure a significant difference on my
> laptop.  The performance was equally terrible, at around 940 TPS +/-
> 10 including connection time.  Adding to open commitfest.

I wanted to comment on that this morning but forgot as my mind was
driven away by another problem.  What if you used the Julien-Rouhaud's
method of a custom script with only ";" used as query and -c?  This
won't run any queries, and will stress authentication.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Cache invalidation after authentication (on-the-fly role creation)
Next
From: Andres Freund
Date:
Subject: Re: Cache invalidation after authentication (on-the-fly rolecreation)