PG Admin 4.28 is crashing while viewing 10M row data

From: Sachin Kumar <sachinkumaras(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PG Admin 4.28 is crashing while viewing 10M row data
Date: 2020-11-22 16:45:47
Message-ID: CALg-PKDTeex+wovAeE8-dnjK6Z9Hn7=fGN0sx_H_xA11X=Qs4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Expert,
I am updating 10 Million records using COPY command in a table, the table
is updated in a minute, but when I am trying to view all row. PGadmin 4.28
which I am using in chrome is getting crashed. I tried it 4 times and it
crashed 3 times. After viewing this 10M row the other queries are very
running slow.
is there any process to clear the buffer in PGAdmin or process through
which the quey in PGAdmin runs at its normal speed?
Please guide me on how to fix this issue.

--

Best Regards,
Sachin Kumar

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-11-22 16:55:15 Re: PG Admin 4.28 is crashing while viewing 10M row data
Previous Message Michel SALAIS 2020-11-19 22:31:59 RE: select locks table for updates