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
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