Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Date
Msg-id 16154.1249747326@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
List pgsql-bugs
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> Now that we have SQL-level CONNECT privilege, I wonder just how much
>> functionality would be lost if we got rid of the flat files and told
>> people they had to use CONNECT to do any per-user or per-database
>> access control.
>>
>> The main point I can see offhand is that password checking would have
>> to be done a lot later in the startup sequence, with correspondingly
>> more cycles wasted to reject bad passwords.

> Is this a TODO?

Well, it's a TO-THINK-ABOUT anyway.  I think the appropriate next step
would not be to write code, but to do a detailed investigation of what
would be gained or lost.  I don't remember exactly what we do with the
flat-file contents.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Next
From: Alvaro Herrera
Date:
Subject: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance