On Thu, Aug 9, 2018 at 3:10 PM, Rob Richardson <interrob...@yahoo.com> 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. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
