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

HI Ashok,

Please find the command i am using to upload 10 million data into a table.

*copy command to update records*
copy hk_card_master_test from
'C:/inetpub/wwwroot/cards/media/static/rawsheet_001-000.csv' with delimiter
E'\t' csv header encoding 'ISO_8859_5'

I am not using the Vacuum command during the update? NO, I am not
Vacuuming this large table.
I am using the analyze command for other queries.

I am not aware of the Vacuum command functionality. Please if you can help
in understanding Vacuum query.

On Mon, Nov 23, 2020 at 10:23 AM dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
wrote:

> Hi Sachin,
>
> Let me know-how did you give a commit statement during update? Did you try
> use Vacuum and analyze command during update? are you frequently Vacuuming
> this table large table .
>
> if the postgresql is running on Linux then run it by batch with
> intermediate commit.
>
>
>
> Thanks & Best Wishes,
>
> Ashok
>
>
>
>
>
>
>
> Thanks & Best Wishes,
>
> Ashok
>
>
>
>
> ---------------------------------------------------------------------------------------------------------------------
>
> Ashokkumar Mani *(OCP12c/11g/10g/9i, AWS SAA, M103)*
>
> *Dubai** , UAE* *| BLR , INDIA*
>
> M: *+971 54 723 0075 *| *+91 90086 70302 | *WApp :* +91 81975 99922*
>
> W: https://dbatocloudsolution.blogspot.in/
> <http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com
>
>
> 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