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

toruvinn wrote:
> On Wed, 15 Jul 2009 16:02:09 +0200, Alvaro Herrera
> <alvherre@commandprompt.com> 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.