Hi Merlin: Any EXPLAIN on the query affected? size of indexes before and after reindex? Regards, Daniel. > El 1 feb 2017, a las 13:38, Merlin Moncure <mmoncure@xxxxxxxxx> escribió: > > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
