"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