reassign owned requirement of locks

2020-03-06 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/sql-reassign-owned.html
Description:

reassign owned document didn't say its requirements of locks


Re: No mention about somaxconn

2020-03-06 Thread Andres Freund
Hi,

On 2020-03-03 10:48:56 +0900, Tatsuo Ishii wrote:
> Currently there's no mention about net.core.somaxconn parameter needs
> to be adjusted if max_connections is large and UNIX domain socket is
> used for connection. Since the default for the kernel parameter is
> small (typically 128), it is easy to hit the limitation and you will
> get errors something like:
> 
> could not connect to server: Resource temporarily unavailable
> 
> I don't know if this should be applied to other OS as well though.

Yea, that'd be good. Care to suggest a patch?

Greetings,

Andres Freund