I've rebuilt the indexes on Bug.fti on all databases, and the query is now usually < 500ms with occasional spike to < 1s. The Bug table is still bloated - I can't repack that without causing downtime.
I've rebuilt the indexes on Bug.fti on all databases, and the query is now usually < 500ms with occasional spike to < 1s. The Bug table is still bloated - I can't repack that without causing downtime.