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

From: Tom Lane
Subject: Re: BUG #4919: CREATE USER command slows down system performance
Date: ,
Msg-id: 22612.1247669956@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera)
Responses: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Marko Kreen)
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Bruce Momjian)
List: pgsql-bugs

Tree view

BUG #4919: CREATE USER command slows down system performance  ("Lauris Ulmanis", )
 Re: BUG #4919: CREATE USER command slows down system performance  (Heikki Linnakangas, )
  Re: BUG #4919: CREATE USER command slows down system performance  ("Lauris Ulmanis", )
   Re: BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )
    Re: BUG #4919: CREATE USER command slows down system performance  (toruvinn, )
     Re: BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )
      Re: BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
       Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Marko Kreen, )
        Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (David Wilson, )
         Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
         Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Marko Kreen, )
       Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Bruce Momjian, )
        Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
         Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )
          Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
           Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
            Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )
             Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
              Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )
               Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane, )
         Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Bruce Momjian, )
    Re: BUG #4919: CREATE USER command slows down systemperformance  ("Lauris Ulmanis", )
 Re: BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera, )

Alvaro Herrera <> 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.

            regards, tom lane


pgsql-bugs by date:

From: Alan Pinstein
Date:
Subject: Re: BUG #4921: ltree @> ltree[] operator shouldn't fail if ltree[] is empty
From: "Jim Michaels"
Date:
Subject: BUG #4924: pg_restore hangs, does nothing