"Ben Young" <Ben(dot)Young(at)etrials(dot)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