CODEWITHSUNDEEP
pgadminpgadmin-4
ROBERT RICHARDSON
ROBERT RICHARDSON

Reputation: 2299

How do I get pgAdmin4's result grid to load all results?

When I run a query in pgAdmin4 that returns several thousand rows, I can only scroll down a short way in the result grid. If I scroll to the bottom, the grid refreshes itself and the scroll thumb jumps up to a position near the top of the scroll bar. I understand that this is because pgAdmin4 only loads a fixed number of records. When I try to scroll down further than that number, pgAdmin4 loads the next batch of records and repositions the thumb to the top of the newly loaded result lines.

There is a parameter somewhere that controls the number of records initially loaded into pgAdmin4's result grid. I once had that value set to 10000000 (ten million). Apparently, somewhere it got reset to its default value. Now, I can't find it. Where is that parameter?

Upvotes: 1

Views: 2140

Answers (1)

ROBERT RICHARDSON
ROBERT RICHARDSON

Reputation: 2299

I found it. It's in config.py. On my machine, it's in C:/Program Files (x86)/pgAdmin4/v3.2/web. The line is 

ON_DEMAND_RECORD_COUNT = 1000

I changed that value to 10000000 and got the behavior I want.

Upvotes: 3

Related Questions