To: "Vucomir Ianculov"
Cc: pgsql-performance@postgresql.org, "Tom Lane"
Sent: Saturday, February 4, 2017 8:38:34 PM
Subject: Re: [PERFORM] pgsql connection timeone
Well, you can try switching to urandom, see
http://stackoverflow.com/questions/137212/how-to-solve-perform
ed, 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: *p
y, 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 Iancul
#x27;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: [PERFOR
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 postgre
quot;
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:0
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 E
Hi,
before timeout started this was the last automatic vacuum entry's:
2017-01-25 10:47:07 EET [5995-1] LOG: automatic vacuum of table
"13Tim07Tuning.pg_catalog.pg_attribute": index scans: 1
pages: 0 removed, 261 remain
tuples: 3547 removed, 8812 remain
buffer usage: 927 hits, 112 misses,
