Re: [PERFORM] Slow query after 9.3 to 9.6 migration

2017-01-04 Thread Kevin Grittner
On Tue, Dec 27, 2016 at 5:50 PM, Flávio Henrique wrote: > I can see some buffers written that tells me > that something is wrong. Try running VACUUM FREEZE ANALYZE on all tables involved in the query (or just run it as a superuser on the whole database). Do *not* use the FULL option. Among oth

Re: [PERFORM] Unable to connect to server

2017-01-04 Thread Andreas Kretschmer
Vucomir Ianculov wrote: > HI Andreas, > > thanks for your replay, i have checked connection number for the last 3 mouths > and maximum number of connection was 300, so i can reduce this is it's cousin > the issue. > during this error server was 99% idle, the only thing is that there was a > pg_d

Re: [PERFORM] Unable to connect to server

2017-01-04 Thread Vucomir Ianculov
HI Andreas, thanks for your replay, i have checked connection number for the last 3 mouths and maximum number of connection was 300, so i can reduce this is it's cousin the issue. during this error server was 99% idle, the only thing is that there was a pg_dump running on one of the DB, can t

Re: [PERFORM] Unable to connect to server

2017-01-04 Thread Andreas Kretschmer
Vucomir Ianculov wrote: > Hi, > > today i head a issue with pgsql 9.3, a lot of clients complained that they are > unable to connect to the server. > when i have checked the logs i sow a lot of > FATAL: canceling authentication due to timeout you can increase authentication_timeout, default is