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

Reply via email to