| From: | Daniel Blanch Bataller <daniel(dot)blanch(dot)bataller(at)gmail(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PSA: upgrade your extensions |
| Date: | 2017-02-01 15:18:28 |
| Message-ID: | ADBA8F9D-2BD2-4FED-B937-6B00556E1DE7@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)gmail(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitalii Tymchyshyn | 2017-02-01 17:11:12 | Re: pgsql connection timeone |
| Previous Message | Vucomir Ianculov | 2017-02-01 12:51:58 | Re: pgsql connection timeone |