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

From Alvaro Herrera
Subject Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Date
Msg-id 20090808192039.GB9155@alvh.no-ip.org
Whole thread Raw
In response to Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:

> In some sense this is a bootstrap problem: what does it take to get to
> the point of being able to read pg_database and its indexes?  That is
> necessarily not dependent on the particular database we want to join.
> Maybe we could solve it by having the relcache write a "global" cache
> file containing only entries for the global tables, and load that before
> we have identified the database we want to join (after which, we'll load
> another cache file for the local entries).

This sounds good, because autovacuum could probably use this too.

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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance