12

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?

Negin Zarbakhsh
  • 167
  • 1
  • 3
  • 13
  • 5
    pgAdmin4 is hybrid application, it is not pure desktop application like pgAdmin3, so it will run slower than pgAdmin3. – Murtuza Z May 15 '17 at 04:58
  • 5
    pgAdmin4 is based on web technologies (HTML, JavaScript etc.) and uses WebKit (as I remember) as its front-end. Thus it is inefficient by default. pgAdmin3 is the better choice (I hope that its support will not be dropped), or look for some [third-party clients](https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools). Or, as an option, upgrade your hardware :o) – Abelisto May 15 '17 at 11:57
  • @n33rma is the error of pgadmin 4 desktop runtime has stopped working is because of that? – Negin Zarbakhsh May 18 '17 at 11:40
  • @Abelisto this error: pgadmin 4 desktop runtime has stopped working is because of my hardware.? because my database include 1 million quay. – Negin Zarbakhsh May 18 '17 at 11:42
  • Most probably...Yes. On Desktop mode, pgAdmin4 is wrap under Qt4/5 WebEngine, most of the time its Qt which crashes and can't handle it. If you want to take full advantage of pgAdmi4, I suggest you to install it on Web Server and use it from Browser. https://www.pgadmin.org/docs/pgadmin4/1.x/server_deployment.html# – Murtuza Z May 19 '17 at 05:44
  • 2
    You can still download and use pgAdmin 3. It will give you a warning (because it supports PostgreSQL 8.4 to 9.5), but it will work with 9.6. That's what I do. – Jean-François Beauchef Jun 01 '17 at 18:27
  • 2
    pgAdmin 3 is no longer supported and the developers recommended the use of the version 4. Unfortunately for this web-centric application designed to look like a desktop app, pgAdmin 4 is so slow. But at least it is usable. I really do not understand why do we need all web-centric apps these days. – AER 4AF Jun 17 '17 at 01:53
  • 2
    pgAdmin v4 is terribly slow compared to v3. I noticed issues in pgAdmin 3 trying to create a table with a bigserial where the db was created in pgAdmin v4 (using postgres 9.6). So it seems some tasks may work in v3, while others may not work so well. – mg1075 Jul 21 '17 at 15:57
  • I'm upvoting just because I hate the slowliness of pgAdmin4 and because pgAdmin3 is not working with Postgres 10 :( (and because I don't like web apps used as desktop without a browser) – Matthieu Sep 25 '18 at 14:21

1 Answers1

3

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

Florian Weimer
  • 32,022
  • 3
  • 48
  • 92
Nabil7400
  • 27
  • 3
  • 1
    PgAdmin3 1.22.2 doesn't work properly with Windows 10 (several error messages on startup). In addition: almost no difference to pdAdmin 4 in terms of performance. – Trinimon Dec 01 '17 at 09:55