On Wed, Nov 25, 2009 at 11:25:02AM -0500, Jesse Vincent wrote:
> 
> > I think your suggested new index in group is correct; that's
> > eliminated some more slow queries. I think I'll try and put up a
> > set of annotated additional postgres indexes on the wiki, in lieu
> > of future updates to the indexes created by the schemas shipped with
> > RT.
> 
> (And possibly influencing future index updates as shipped by the vendor ;)

I've created <http://wiki.bestpractical.com/view/DatabaseIndexes>

I fear that I've lost some of the full rationale for the indexes
I've put in in the frenzy of preparation for our upgrade, but hopefully
this is still useful.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford

Attachment: signature.asc
Description: Digital signature

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to