3

Some time ago I've moved from mySql's phpMyAdmin to postgres's pgAdmin 4. What I've noticed is that pgAdmin's query tool has very slow autocompletion. Usually it's just faster to type keyword/identifier on your own than waiting till autocompletion will appear.

When I click ctrl+space it takes around 0.5-1 second to appear, horrible.

In compairsion when I use autocompletion in phpMyAdmin, it appears almost immadiately.

My question is, does it work so slowly for you too? Is there any way to fast it up? Or I have to use some third party program to get faster autocompletion?

Cheers.

[EDIT]

I've also tried the online trial of pgAdmin and here autocompletion is a little bit faster but still not even close to phpMyAdmin's one.

USHKA
  • 647
  • 4
  • 18
  • Is it slow when you autocomplete a keyword like `CREATE` or `DATABASE`, or when you autocomplete a table or column name? – Laurenz Albe Nov 19 '20 at 06:39
  • It doesn't really matter. My autocompletion is slow all the time :( But if you ask then does it work nice for you? – USHKA Nov 19 '20 at 09:47
  • I never use pgAdmin. I asked, because if only object names were slow, it might be the slow database connection. If autocompletion of `CREATE` is slow, that seems like a code problem. – Laurenz Albe Nov 19 '20 at 09:53
  • Ok thanks. Are you using postgreSQL too? Maybe you can recommend some better db management software than pgadmin? – USHKA Nov 19 '20 at 09:55
  • For accessing the database via SQL I only use `psql`. It's simply the best and most comfortable. For managing the database, I use `bash`, `vi` and other operating system tools. – Laurenz Albe Nov 19 '20 at 09:57
  • I am facing the same problem. It is unworkable. Try using DBeaver instead, or have you come to a solution? – Rafs May 31 '23 at 15:38
  • Unfortunately no solution, in the end I switched to DBeaver and can tell you it's way better. – USHKA Jun 01 '23 at 11:52

1 Answers1

1

Just to add to this, the autocompletion has made pgadmin unusable for me. If I briefly pause to think about a query while I'm navigating, suddenly a list will appear over the SQL I'm looking at, and the arrow key context will be hijacked to navigate that list instead, which is, as you can imagine, jarring.

Rupert Hardy
  • 11
  • 2
  • As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 30 '22 at 10:46