PSA: upgrade your extensions

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: PSA: upgrade your extensions
Date: 2017-02-01 12:38:04
Message-ID: CAHyXU0wSxKY3OT1Hybk_Gy43ZOyr-Ly_XvCZxRPk+_D+yh2anQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vucomir Ianculov 2017-02-01 12:51:58 Re: pgsql connection timeone
Previous Message David Steele 2017-01-31 15:20:18 Re: Backup taking long time !!!