Skip to Content.
Sympa Menu

grouper-users - [grouper-users] updating member change times slows the DB

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] updating member change times slows the DB

Chronological Thread 
  • From: Jim Fox <>
  • To: grouper users list <>
  • Subject: [grouper-users] updating member change times slows the DB
  • Date: Tue, 1 Mar 2011 10:54:40 -0800 (PST)

A couple of weeks ago I activated the update of membership changes:

groups.updateLastMembershipTime = true

This did update membership change times, but also caused a major
hit on our postgres DBMS. Response times on our web service
went from 1-2 sec to 5-10 sec. Looking at the database we saw
continually running update statements like:

update grouper_groups set last_membership_change = $1 where id in ($2,

As soon as one completed another started - or so it seemed.
The load average on our DB server went from below 1 to above 7.
Setting the updateLastMembershipTime back to false removed the
update commands and immediately improved response times.

This is standard grouper 1.6.0. During normal daytime operations
we see membership changes every five to ten seconds.


Archive powered by MHonArc 2.6.16.

Top of Page