Hi,
I have PostgreSQL v12.3 (x64) installed on my Laptop running Windows 10 Home Single Language (64-bit).
In two or three times since I fresh install the PostgreSQL and windows on 17-05-2020, 06:04:56 (GMT).
By two or three times I mean, if this slow connection problem happen, than it wil occur in a view days in a row. Then it will return to normal with fast login/connection process.
I've try to restart the laptop, restart the service but nothing give the sign to improve the slow login/connection process.
I've also try to turn off the log_hostname config in postgresql.conf and try to turn off the Windows Firewall, Windows Defender Real-Time Scanner but nothing works to improve the slow login connection.
I've also try to check the Postgres Log file but not much error shows in the log except for this error that appears a few time:
2020-07-22 14:43:22.312 +00 [13740] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.
This problem happens with all of the application such as psql, pgAdmin, Navicat, all with the same symptoms of slow login/connection to my PostgreSQL v12.3 (x64) service and if connected, then it will be easy to disconnected.
If needed my laptop specs are:
- Intel Core i7-9750H
- 16GB of RAM
- Samsung SSD 970 EVO Plus 2TB
Is database size can affect this connection time required to start a database session?
FYI one of my database has size of 209GB, but currently I'm not using or connect to that database.
Thanks in advance.
Regards,
Surya