I was just troubleshooting a strange performance issue with pg_trgm
(greatest extension over) that ran great in testing but poor in
production following a 9.6 in place upgrade from 9.2. By poor I mean
7x slower. Problem was resolved by ALTER EXTENSION UPDATE followed by
a REINDEX on the impacted table. Hope this helps somebody at some
point :-).
merlin