I uploaded the backport now, sorry for dragging this so long! This needs
Steve or Colin to process now.
** Changed in: postgresql-common (Ubuntu Hardy)
Status: Triaged => Fix Committed
** Changed in: postgresql-common (Ubuntu Hardy)
Importance: Undecided => Medium
** Description changed:
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.:
apoll...@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.
--
Reading supplementary groups is too slow
https://bugs.launchpad.net/bugs/364669
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
