| 2009-07-19 13:20:33 |
Martin Pitt |
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@procrastination:~$ sudo time perl -I /usr/share/postgresql-common/ -MPgCommon -e 'change_ugid(29,29)'
4540.63user 426.61system 1:22:49elapsed 99%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (0major+678714minor)pagefaults 0swaps
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 |
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@procrastination:~$ sudo time perl -I /usr/share/postgresql-common/ -MPgCommon -e 'change_ugid(29,29)'
4540.63user 426.61system 1:22:49elapsed 99%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (0major+678714minor)pagefaults 0swaps
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://bazaar.launchpad.net/~pitti/postgresql/common/revision/873 (in production use for over half a year without apparent regressions).
Test case: see above
For verification, you should also run the test suite with
sudo /usr/share/postgresql-common/testsuite
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. |
|
