[Rt-devel] New index on groupmembers table

Joby Walker joby at u.washington.edu
Fri Jun 22 15:03:30 EDT 2007

I've noticed some significant improvement by adding the following index:

CREATE INDEX groupmembers1 on groupmembers (groupid, memberid);

Currently the groupmembers table is not indexed (apart from the PK), and
there are several operations that make use of the groupmembers table and
not the cachedgroupmembers table.  For example (in the stock RT) on
*every* page load RT checks to see if the currentuser is Privileged.


Joby Walker
C&C SSG, University of Washington

More information about the Rt-devel mailing list