Re: [PERFORM] PSA: upgrade your extensions
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 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
Re: [PERFORM] Chaotic query planning ?
Albe Laurenz wrote > […] > Experiment with raising join_collapse_limit and from_collapse_limit to 11. Thank you, this solve the problem. > Alternatively, optimize the join order by hand and don't tune the parameters. What is surprising is that there is no apparent/logical optimal strategy. Best regards, -- PI -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] pgsql connection timeone
Just a wild guess, but did you check your random source? We had similar problems in Oracle and had to switch to /dev/urandom. It can be done with a system variable setting. On Wed, Feb 1, 2017, 7:52 AM Vucomir Ianculov wrote: > can anyone help me with my problem? > i'm really don't know from when the problem can be. > > > > -- > *From: *"Vucomir Ianculov" > *To: *"Tom Lane" > *Cc: *pgsql-performance@postgresql.org > *Sent: *Saturday, January 28, 2017 12:03:55 PM > > *Subject: *Re: [PERFORM] pgsql connection timeone > > Hi Tom, > > this is the entry from pg_hba.conf > host all all 0.0.0.0/0 md5 > > i needed to restart postgres service to be able to accept new connection, > witch it strange becouse there was no load on the server and it head a lot > of free ram. > > > > > -- > *From: *"Tom Lane" > *To: *"Vucomir Ianculov" > *Cc: *pgsql-performance@postgresql.org > *Sent: *Wednesday, January 25, 2017 3:15:28 PM > *Subject: *Re: [PERFORM] pgsql connection timeone > > Vucomir Ianculov writes: > > i'm seeing a lot of connection time out in postgresql log > > > 2017-01-25 11:09:47 EET [6897-1] XXX@YYY FATAL: canceling > authentication due to timeout > > 2017-01-25 11:10:15 EET [6901-1] XXX@YYY FATAL: canceling > authentication due to timeout > > 2017-01-25 11:10:17 EET [6902-1] xxx@YYY FATAL: canceling > authentication due to timeout > > So ... what authentication method are you using? > > regards, tom lane > >
Re: [PERFORM] PSA: upgrade your extensions
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 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] pgsql connection timeone
can anyone help me with my problem? i'm really don't know from when the problem can be. - Original Message - From: "Vucomir Ianculov" To: "Tom Lane" Cc: pgsql-performance@postgresql.org Sent: Saturday, January 28, 2017 12:03:55 PM Subject: Re: [PERFORM] pgsql connection timeone Hi Tom, this is the entry from pg_hba.conf host all all 0.0.0.0/0 md5 i needed to restart postgres service to be able to accept new connection, witch it strange becouse there was no load on the server and it head a lot of free ram. - Original Message - From: "Tom Lane" To: "Vucomir Ianculov" Cc: pgsql-performance@postgresql.org Sent: Wednesday, January 25, 2017 3:15:28 PM Subject: Re: [PERFORM] pgsql connection timeone Vucomir Ianculov writes: > i'm seeing a lot of connection time out in postgresql log > 2017-01-25 11:09:47 EET [6897-1] XXX@YYY FATAL: canceling authentication due > to timeout > 2017-01-25 11:10:15 EET [6901-1] XXX@YYY FATAL: canceling authentication due > to timeout > 2017-01-25 11:10:17 EET [6902-1] xxx@YYY FATAL: canceling authentication due > to timeout So ... what authentication method are you using? regards, tom lane
[PERFORM] PSA: upgrade your extensions
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance