"Ben Young" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to