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

От: Alvaro Herrera
Тема: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
Дата: ,
Msg-id: 20090715144735.GG4551@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: 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)
Список: pgsql-performance

Скрыть дерево обсуждения

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", )

toruvinn wrote:
> On Wed, 15 Jul 2009 16:02:09 +0200, Alvaro Herrera
> <> wrote:
>> My bet is on the pg_auth flat file.  I doubt we have ever tested the
>> behavior of that code with 1 billion users ...

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

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


В списке pgsql-performance по дате сообщения:

От: Scott Mead
Дата:
Сообщение: Re: Performance comparison between Postgres and Greenplum
От: "Haszlakiewicz, Eric"
Дата:
Сообщение: Re: CREATE USER command slows down when user count per server reaches up to 500 000