Launchpad itself

  1. Bug #739051
  2. Comment #8

Comment 8 for bug 739051

Revision history for this message
William Grant (wgrant) wrote :

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.