Unable to view 15 MB Json data which I stored as JSONB data type in pgadmin4 version 7.1

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

https://www.pgadmin.org

Other

2.39k stars 629 forks source link

Unable to view 15 MB Json data which I stored as JSONB data type in pgadmin4 version 7.1 #6510

Open Ravisankar97 opened 1 year ago

Ravisankar97 commented 1 year ago

I am using timescale db to store timeseries data and json data. Why I unable to view 15 MB json data in table column which is JSONB datatype in pgadmin tool ? I am usning timescale db to store timeseries data and json data. but i could see 2 MB json data.

Ravisankar97 commented 1 year ago

Hi Team,

Any updates on this ?

pravesh-sharma commented 9 months ago

Did some debugging for the issue, I tried with a 25 MB JSON file, and it loads slowly but I can view it. This issue is more related to browser/nwjs as I also tried for text type on textarea with a 10 MB file which I can read easily on Firefox but on Chrome page crashes.

jbeynar commented 7 months ago

This is still present issue on pgAdmin 7.8; it is impacting a lot - you can't work with large JSON. We have following observation:

This is reproducable on: Windows 10 Home with 7.8 and 8.2 MacOS Ventura 13.6.3 reproduced on 7.8

But, this bug does not exists on MacOS Ventura 13.6.3 and pgAdmin4 8.2.