Well, you can try switching to urandom, see http://stackoverflow.com/questions/137212/how-to-solve-performance-problem-with-java-securerandom, second answer.
сб, 4 лют. 2017 о 11:45 Vucomir Ianculov <vukomir@xxxxxxxxx> пише:
Hi Vitalii,
no, hove can i check it? searched but did not find any useful information .
Thanks,
Br,
VukoFrom: "Vitalii Tymchyshyn" <vit@xxxxxx>
To: "Vucomir Ianculov" <vukomir@xxxxxxxxx>, "Tom Lane" <tgl@xxxxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Wednesday, February 1, 2017 7:11:12 PM
Subject: 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 <vukomir@xxxxxxxxx> wrote:can anyone help me with my problem?
i'm really don't know from when the problem can be.From: "Vucomir Ianculov" <vukomir@xxxxxxxxx>
To: "Tom Lane" <tgl@xxxxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Saturday, January 28, 2017 12:03:55 PM
Subject: Re: [PERFORM] pgsql connection timeoneHi Tom,
this is the entry from pg_hba.confhost 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" <tgl@xxxxxxxxxxxxx>
To: "Vucomir Ianculov" <vukomir@xxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: pgsql connection timeone
Vucomir Ianculov <vukomir@xxxxxxxxx> 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
