| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | toruvinn <toruvinn(at)lain(dot)pl> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: BUG #4919: CREATE USER command slows down system performance |
| Date: | 2009-07-15 14:47:35 |
| Message-ID: | 20090715144735.GG4551@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
toruvinn wrote:
> On Wed, 15 Jul 2009 16:02:09 +0200, Alvaro Herrera
> <alvherre(at)commandprompt(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-15 14:59:16 | Re: BUG #4919: CREATE USER command slows down system performance |
| Previous Message | Andreas Pflug | 2009-07-15 14:21:33 | Re: 1-Click 8.4 win32 fails to run scripts |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-15 14:59:16 | Re: BUG #4919: CREATE USER command slows down system performance |
| Previous Message | Scott Marlowe | 2009-07-15 14:30:40 | Re: Poor overall performance unless regular VACUUM FULL |