From: | dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Sachin Kumar <sachinkumaras(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PG Admin 4.28 is crashing while viewing 10M row data |
Date: | 2020-11-23 04:53:13 |
Message-ID: | CAEz7P_ubL=b2ysrEWtTV6sKUgVKHU3+zm-QtoQPFjwC5G0S7-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sachin Kumar | 2020-11-23 05:06:15 | Re: PG Admin 4.28 is crashing while viewing 10M row data |
Previous Message | David G. Johnston | 2020-11-23 04:44:42 | Re: PG Admin 4.28 is crashing while viewing 10M row data |