Re: Opening queries in new window, record caching when scrolling

There is a setting you need to change to open query tool in new window.

Goto:
'File' -> 'Preferences' -> 'SQL Editor' -> 'Open in new browser tab'
(Set this option to True)

[image: Inline image 1]

Regarding loading the result at once, loading the result in chunks helps
us improve the performance in server-client architecture.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer <rmercer(at)getspatial(dot)com>
wrote:

> Hi,
>
> One of the items that was noted in the release of 1.6 was the ability to
> move queries into a new window, allowing for use on multiple screens. I
> was wondering if anyone has been able to make this work. I've given it a
> shot, but seem to be missing a step in the process.
>
> The one way I've seen to open a new window is by Right Clicking on the
> pgAdmin 4 logo at the top left, and choosing the option to Open in a New
> Window. The result of this is a new window, but in the form of a tab
> created in the existing window. Is there a way to break that out
> separately to its own window? I thought with the beta version that Dave
> Page released shortly before 1.6 was released, that I had gotten this to
> work, but now I'm not sure.
>
> The other feature I wonder about is whether there is a setting to load the
> entire result into the window at once. Right now, when I run a query, that
> returns say 13000 rows, it runs successfully. When I grab the scroll bar
> to scroll to the bottom, it runs down through about 1000 records, then the
> scroll bar jumps halfway back up again, as it has obviously loaded another
> batch of records into the cache. Is there any setting to change so that I
> can scroll to the bottom of the results without having to continually load
> records into the cache? Any input would be much appreciated.
>
> For tech details, I'm running this on a Windows 7, Intel i7, 16GB RAM.
>
> On a personal note, I want to say that the 1.6 release of pgAdmin4 is a
> huge step for the software. It is far more stable, loads faster, and seems
> to be approaching parity with what pgAdmin3 offered. As someone who was
> pretty critical of the initial release of the software, I want to
> acknowledge that it is clear the developers have been working hard to
> address the concerns that were expressed. It is very much appreciated.
>
> Thanks,
>
> Russell
>