Re: Slow Restoration of a template1 Database (ALTER GROUP)
This is a discussion on Re: Slow Restoration of a template1 Database (ALTER GROUP) within the Pgsql Performance forums, part of the PostgreSQL category; --> "Ben Young" <Ben.Young@etrials.com> writes: > When trying to restore my template1 database (7.3.4) I am > experiencing very long ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 11:06 AM
| ||||
| ||||
 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend      |
 |
« Re: Slow Restoration of a template1 Database (ALTER GROUP)
|
Re: Slow Restoration of a template1 Database (ALTER GROUP) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:40 PM.
