[PERFORM] PSA: upgrade your extensions - Mailing list pgsql-performance

From Merlin Moncure
Subject [PERFORM] PSA: upgrade your extensions
Date
Msg-id CAHyXU0wSxKY3OT1Hybk_Gy43ZOyr-Ly_XvCZxRPk+_D+yh2anQ@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORM] PSA: upgrade your extensions
Re: [PERFORM] PSA: upgrade your extensions
List pgsql-performance
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


pgsql-performance by date:

Previous
From: David Steele
Date:
Subject: Re: [PERFORM] Backup taking long time !!!
Next
From: Vucomir Ianculov
Date:
Subject: Re: [PERFORM] pgsql connection timeone