New answers tagged pgadmin
I am adding 1k inserts by connection to the base, so I don't think it's related. I think it is related. You are probably adding exactly 1001 rows in each batch. All these numbers are multiples of 1001.
A PostgreSQL server connection dropping after 10-15 minutes is almost certainly being caused by a state-tracking firewall (possibly using Network Address Translation (NAT)) between the client and the server. Many such firewalls have default timeouts of 15 minutes (900 seconds). The three server-side parameters, tcp_keepalives_idle, tcp_keepalives_interval, ...
Top 50 recent answers are included