I installed PostgreSQL 9.6.3-1 on my windows 10 laptop. The processor of my laptop is Intel(R)Core (TM)i7-5500U CPU @ 2.4GHZ and installed Memory is 8.00GB. pgadmin 4 is too slow to open table of my databases. I have just made schema of table and i haven't import any data but it is slow to open my database. What should I do? should I install any Prerequisite application or downgrade to pgadmin3?
Programming languages are not made equal. Python is four times slower than languages like C++ or Java. This could explain that pgAdmin 4 is slow.
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.
But there is another way in pgAdmin4: Close connections to the databases you would like to delete by right-clicking on it and selecting "Disconnect database..." Left-click on "Databases" (One up in the hierarchy: The folder that contains all your databases) Select tab "Properties" on the right hand side.
I am confronted with the same problem by installing PostgreSQL 9.6. Just install PgAdmin3 1.22.2 and everything will become normal again
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