Re: PG Admin 4.28 is crashing while viewing 10M row data

Hi David,
I want to verify the records updated in the table, once the record is
updated I have to run a query on all the records. to filter status.

Restarted the service, but what will be the solution to verify 10 Million
updated data.

On Sun, Nov 22, 2020 at 10:25 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

>
> On Sunday, November 22, 2020, Sachin Kumar <sachinkumaras(at)gmail(dot)com>
> wrote:
>
>> 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.
>>
>>
> Stop and restart the program?
>
> What do you hope to do with 10M full records displayed on screen (even if
> pagination is involved...)?
>
> David J.
>
>

--

Best Regards,
Sachin Kumar