This becomes easy to fix once we upgrade to PostgreSQL 9.1. We can use GIN for DSPC.fti and a GiST trigram index for DSPC.name, and eliminate the join against SPR using SPPH.sourcepackagename. This makes it ~60ms for most things on DF.
This becomes easy to fix once we upgrade to PostgreSQL 9.1. We can use GIN for DSPC.fti and a GiST trigram index for DSPC.name, and eliminate the join against SPR using SPPH.sourcepack agename. This makes it ~60ms for most things on DF.