Wow, well done Microsoft, I am looking forward to trying this out. PgAdmin is an embarrassment to the incredible Postgres community - it’s SQL editor is virtually useless, so slow and buggy. Probably because PSQL is the favoured option for most of the contributors, I’m not a huge fan of command line editing, I much prefer tools like Sublime Text, so I use Sublime Text 3 for SQL editing and it’s wonderful - blazing speed, rock solid, quite happy to display a few million rows, such queries would have no chance in Pgadmin. Also has a pg specific syntax highlighting plugin.
Dbeaver just has one glaring issue in my mind -it has a VERY slow pace of development and issue managment. They had something like 900 issues open on their github the last time i saw it with around 200 of them having no replies at all. I was trying it out for sql server though so i don't know if it does better or not for postgres
The large number of open issues is a valid complaint although that is more of an indicator of popularity. As for the pace of development I’d challenge you to name another SQL IDE that releases updates twice a month. (Note: The exception was the last release cycle which took 3 weeks rather than 2 but that was for the 6.0 release)