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

[Viktor]

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 u.washington.edu>
To: rt-devel at lists.bestpractical.com
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: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>