| From: | Jeff Janes <jeff(dot)janes(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 19:48:42 |
| Message-ID: | CAMkU=1wYiyA0H-5DyTdAC9UEbTn47Fd+jzshPYvTEh4fpWRrnA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Feb 1, 2017 at 4:38 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> 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 :-).
>
It was probably the implementation of the triconsistent function for
pg_trgm (or I would like to think so, anyway).
But if so, the REINDEX should not have been necessary, just the ALTER
EXTENSION UPDATE should do the trick. Rebuiding a large gin index can be
pretty slow.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2017-02-02 12:24:52 | Re: PSA: upgrade your extensions |
| Previous Message | Vitalii Tymchyshyn | 2017-02-01 17:11:12 | Re: pgsql connection timeone |