Re: [Rt-devel] New index on groupmembers table

Viktor svitter at
Fri Jun 22 16:05:28 EDT 2007

Hello Joby,

do you use RTx::Shredder extension? It adds some useful indexes, like
    "shredder_gm1" UNIQUE, btree (memberid, groupid)
in PostgreSQL.
RTx::Shredder is a must, please be sure to try it!

-----Original Message-----
From: Joby Walker <joby at>
To: rt-devel at
Date: Fri, 22 Jun 2007 12:03:30 -0700
Subject: [Rt-devel] New index on groupmembers table

> 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
> _______________________________________________
> List info:

More information about the Rt-devel mailing list