On Thursday, August 9, 2018, 10:49:29 AM EDT, Rob Richardson <interrobang@yahoo.com> wrote:
Thank you, but that did not work. I am running pgAdmin 4 on a Windows 7 box, executing the file pgAdmin4.exe in my c:/Program Files (x86)/pgAmin4/v3/runtime folder. Should config_local.py be a copy of config.py except for the record count value, or should config_local.py just contain the one line?
On Thursday, August 9, 2018, 10:27:21 AM EDT, Dave Page <dpage@pgadmin.org> wrote:
In pgAdmin 3, if I select a table with a few thousand rows and then click the Edit button, I get a grid of data and a vertical scrollbar. If I drag the scrollbar's thumb to the bottom of the bar, I am taken to the bottom of my result set and the blank row where I can add a new row if I want to. But in pgAdmin 4, the scrollbar's parameters are only calculated on the basis of some subset of the rows in the table. So, I drag the thumb to the bottom of the scrollbar, the selected row goes to some random row part way down the grid, the scroll bar's parameters are recalculated, and the thumb jumps up to somewhere around a third of the way up from the bottom. If I drag the thumb down again, the process repeats. I don't know how many times I have to do that to get to the bottom of the grid and the blank row, since I've never had that much patience. The only way I can get to the bottom is to select some random cell and then hold down the Page Down key until I get there.
Is there some way I can get the scrollbar to behave the same way it does in pgAdmin 3?
Create (or edit if it exists) a file called config_local.py in the same directory as config.py (normally $INSTALLDIR/web). Add the following line to it:
ON_DEMAND_RECORD_COUNT = 10000000
Restart pgAdmin.
That will adjust the number of records retrieved at any one time to 10 million, effectively disabling on demand loading for tables with < 10M rows. Of course, you can adjust that number to something lower (or higher) if you prefer. The default is 1000.