Menu
pgAdmin 4 GUI for postgreSQL is very slow. It takes too much time to even expand a server tree or a database tree. They each took almost 30 seconds to expand. It also hangs while creating a new database or table. Even after loading it took more than a minute just to create and save a new database. It happens almost every time I load the pgAdmin. Is this problem faced just by me or there's something wrong?
My system specifications: PostgreSQL 12.3, Firefox 77.0, Windows 10 64-bit, 8th Gen Quad Core i5 8250u processor, 8GB RAM and 2GB dedicated graphics memory.
In the picture you can see:
Hanged on clicking save. It took more than a minute to save a new database
947
pgAdmin 4 GUI for postgreSQL is very slow. It takes too much time to even expand a server tree or a database tree. They each took almost 30 seconds to expand.
Disk Access. PostgreSQL attempts to do a lot of its work in memory, and spread out writing to disk to minimize bottlenecks, but on an overloaded system with heavy writing, it's easily possible to see heavy reads and writes cause the whole system to slow as it catches up on the demands.
One major difference, however, is that pgAdmin is a web application and DBeaver is a desktop application. You can complete the following operations easily with both tools: Define PostgreSQL server and database connection details. Browse the database and its objects.
Typically discovered through slow response or extended increases in database CPU, the pg_stat_activity view can help to find out what query is causing issues. The pg_stat_activity view contains details of all currently running queries, including user, connection, and timing details.
I had the very same issue, Seems it's related to Windows 10 preferring ipv6 over ipv4.
the following fix worked for me: https://dba.stackexchange.com/questions/201646/
Modify the listen_addresses setting in
the postgresql.conf file usually located under : (unless another data folder specified)
{installation folder}/data/postgresql.conf
to be -> listen_addresses = '127.0.0.1,::1'
The Default value for the listen_addresses is localhost
140
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
