Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pgadmin4 is very slow to open empty tables of database

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?

like image 417
Negin Zarbakhsh Avatar asked May 14 '17 11:05

Negin Zarbakhsh


People also ask

Why is pgAdmin 4 so slow?

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.

Why is my Postgres so 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.

How do I clear my database in pgAdmin 4?

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.


1 Answers

I am confronted with the same problem by installing PostgreSQL 9.6. Just install PgAdmin3 1.22.2 and everything will become normal again

like image 67
Nabil7400 Avatar answered Oct 10 '22 01:10

Nabil7400