• Yorick Peterse's avatar
    Remove trigram indexes for "ci_runners" · 17dd3e89
    Yorick Peterse authored
    These indexes are only used when you search for runners in the admin
    interface. This operation is so rarely used that it does not make sense
    to slow down every update in order to update the GIN trigram indexes.
    
    Removing these indexes should speed up queries such as those used for
    updating the last contact time of CI runners. Locally the timings of
    this query were reduced from ~50 ms to ~25 ms:
    
        UPDATE ci_runners SET updated_at = now(), contacted_at = now();
    17dd3e89
20160810102349_remove_ci_runner_trigram_indexes.rb 930 Bytes