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

From Bruce Momjian
Subject Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Date
Msg-id 200908080413.n784Dn913949@momjian.us
Whole thread Raw
In response to Re: BUG #4919: CREATE USER command slows down system performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > toruvinn wrote:
> >> I was always wondering, though, why PostgreSQL uses this approach and not
> >> its catalogs.
>
> > It does use the catalog for most things.  THe flatfile is used for the
> > situations where the catalogs are not yet ready to be read.
>
> 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?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-bugs by date:

Previous
From: psqluser
Date:
Subject: Connections closed unexpectedly
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance