Re: [BUGS] BUG #4919: CREATE USER command slows down system performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bruce Momjian <bruce@xxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux