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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
