Re: [BUGS] BUG #4919: CREATE USER command slows down system performance - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: [BUGS] BUG #4919: CREATE USER command slows down system performance
Date
Msg-id 20090715144735.GG4551@alvh.no-ip.org
Whole thread Raw
In response to Re: [BUGS] BUG #4919: CREATE USER command slows down system performance  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [BUGS] BUG #4919: CREATE USER command slows down system performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-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.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Poor overall performance unless regular VACUUM FULL
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #4919: CREATE USER command slows down system performance