From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ben Young <Ben.Young@etrials.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow Restoration of a template1 Database (ALTER GROUP)
Date: Tue, 08 Feb 2005 13:57:40 -0500
Message-ID: <9190.1107889060@sss.pgh.pa.us> (raw)
In-Reply-To: <41A1CBC76FDECC42B67946519C6677A901D301FB@pippin.int.etrials.com>
References: <41A1CBC76FDECC42B67946519C6677A901D301FB@pippin.int.etrials.com>
"Ben Young" <Ben.Young@etrials.com> writes:
> When trying to restore my template1 database (7.3.4) I am
> experiencing very long delays. For 600 users (pg_shadow)
> and 4 groups (pg_group) it is taking 1hr and 17 minutes to
> complete. All of the create user statements are processed in a
> matter of seconds, but each alter groups statement takes
> about 10 seconds to process.
I tried doing 1000 ALTER GROUP ADD USER commands in 7.3, and didn't
see any particular performance problem. Could we see the output
of "VACUUM FULL VERBOSE pg_group"?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, Ben.Young@etrials.com
Subject: Re: Slow Restoration of a template1 Database (ALTER GROUP)
In-Reply-To: <9190.1107889060@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox