From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Rob Richardson <interrobang(at)yahoo(dot)com> |
Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Navigation through edit screen is very difficult |
Date: | 2018-08-09 14:27:05 |
Message-ID: | CA+OCxozF-QjV==w9HW=R8Ze_yRcgr_zNbzOOufSbfrjhhcnx-w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Thu, Aug 9, 2018 at 3:10 PM, Rob Richardson <interrobang(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Watson | 2018-08-09 14:33:27 | Re: Navigation through edit screen is very difficult |
Previous Message | Dave Caughey | 2018-08-09 14:20:40 | Re: Navigation through edit screen is very difficult |