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

От: toruvinn
Тема: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
Дата: ,
Msg-id: op.uw34tpgd33x80h@insanity.lain.pl
(см: обсуждение, исходный текст)
Ответ на: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera)
Список: 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", )

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've noticed this behaviour some time ago, on a cluster with 50k+ roles
(not sure about the number now). Restoring the backup took a lot of time,
especially when the users file grew significantly and each additional user
caused PG to rewrite the whole file.
I never bothered to report this, as it's not like the users are
(re)created every day, it was just a one-time run (== some extra time for
another coffee during restore ;-)).
I was always wondering, though, why PostgreSQL uses this approach and not
its catalogs.

Regards,
--
ru


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

От: Scott Marlowe
Дата:
Сообщение: Re: Strange memory behavior with rails - caching in connection?
От: "phb07@apra.asso.fr"
Дата:
Сообщение: Re: cluster index on a table