Re: [PERFORM] PSA: upgrade your extensions

2017-02-02 Thread Merlin Moncure
On Thu, Feb 2, 2017 at 1:18 AM, Jeff Janes wrote: > On Wed, Feb 1, 2017 at 4:38 AM, Merlin Moncure 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 fro

Re: [PERFORM] PSA: upgrade your extensions

2017-02-01 Thread Jeff Janes
On Wed, Feb 1, 2017 at 4:38 AM, Merlin Moncure 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 b

Re: [PERFORM] PSA: upgrade your extensions

2017-02-01 Thread Daniel Blanch Bataller
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 escribió: > > I was just troubleshooting a strange performance issue with pg_trgm > (greatest extension over) that ran great in testing but po

[PERFORM] PSA: upgrade your extensions

2017-02-01 Thread Merlin Moncure
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 t