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

From: Alvaro Herrera
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
Date: ,
Msg-id: 20090808175705.GC6394@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance  (Tom Lane)
Responses: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance  (Tom Lane)
List: pgsql-performance

Tree view

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

Tom Lane wrote:

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

Maybe what we need is not to get rid of the flat files, but to speed
them up.  If we're worried about speed in the pg_authid flatfile, and
come up with a solution to that problem, what will we do with the
pg_database flatfile when it grows too large?  We can't just get rid of
it, because autovacuum needs to access it.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-performance by date:

From: Bruce Momjian
Date:
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
From: Robert Haas
Date:
Subject: Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine