[rt-users] Slow queries building list of privileged users (Postgres)

[Dominic Hargreaves]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100119/fe3e66a0/attachment.sig>