Reading supplementary groups is too slow
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-common (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned | ||
Hardy |
Fix Released
|
Medium
|
Martin Pitt |
Bug Description
Binary package hint: postgresql-common
I'm using the Postgresql packages in an environment having 6,000+ local groups.
In this situation, the change_uid function in PgCommon.pm is unbearably slow. e.g.:
apollock@
4540.63user 426.61system 1:22:49elapsed 99%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (0major+
This has already been fixed in version 90 of postgresql-common, and fixed in Intrepid and later. I'd like this to be fixed in Hardy as well. I will provide a minimal patch against 87
SRU justification: Makes standard PostgreSQL operations, such as starting the cluster from the init script, unbearably slow in environments with many users/groups.
Patch: http://
Test case: see above
For verification, you should also run the test suite with
sudo /usr/share/
This provides a very comprehensive integration test (> 1000 test cases). If that fails for you (I might have some system specific assumptions in there), please compare with the results with the hardy final postgresql-common.
Related branches
Changed in postgresql-common (Ubuntu Hardy): | |
assignee: | nobody → Martin Pitt (pitti) |
tags: |
added: verification-done removed: verification-needed |
The necessary change is
http:// bazaar. launchpad. net/~pitti/ postgresql/ common/ revision/ 873
I'm ok with backporting this.