[Rt-devel] New index on groupmembers table

[Joby Walker]

We haven't updated RTx::Shredder in quite a while...I'll check out the
most recent version.

Joby Walker
C&C SSG, University of Washington


Viktor wrote:
> 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
>>
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel