Re: Slow Restoration of a template1 Database (ALTER GROUP)

"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