MIME-Version: 1.0
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Mon, 7 Sep 2020 15:59:02 +0530
Message-ID: 
 <CAM9w-_=2zjuSTFQrkn=4DUBK7T5zk-SEN4RYn2KPMfHMSkj7UA@mail.gmail.com>
Subject: [pgAdmin][RM5794] Excessive CPU usage while browser is idle
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000191a4b05aeb6b28e"
Precedence: bulk

--000000000000191a4b05aeb6b28e
Content-Type: multipart/alternative; boundary="000000000000191a4905aeb6b28c"

--000000000000191a4905aeb6b28c
Content-Type: text/plain; charset="UTF-8"

Hi Hackers,

Attached is the patch to stop the indefinite growth of graph dataset. This
has caused excessive CPU usage and the patch will reduce it.

Please review.

-- 
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

--000000000000191a4905aeb6b28c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Hi Hackers,</div><div class=3D"gmail_default" style=3D"font-fam=
ily:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fon=
t-family:verdana,sans-serif">Attached is the patch to stop the indefinite g=
rowth of graph dataset. This has caused excessive CPU usage and the patch w=
ill reduce it.</div><div class=3D"gmail_default" style=3D"font-family:verda=
na,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-family:=
verdana,sans-serif">Please review.</div><div><br></div>-- <br><div dir=3D"l=
tr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=
=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr=
"><div><font size=3D"2" color=3D"#000000" face=3D"arial, sans-serif">Thanks=
,</font><div><span style=3D"color:rgb(34,34,34)"><span style=3D"color:rgb(1=
8,22,70)"><font face=3D"arial, sans-serif">Aditya Toshniwal</font></span></=
span><font size=3D"2" color=3D"#000000" face=3D"verdana, sans-serif"><br></=
font></div><div><span style=3D"color:rgb(18,22,70);font-family:Arial,sans-s=
erif">pgAdmin hacker</span><font size=3D"2" color=3D"#000000" style=3D"font=
-family:verdana,sans-serif">=C2=A0| </font><font size=3D"2" color=3D"#00000=
0" face=3D"arial, sans-serif">Sr. Software Engineer</font><font size=3D"2" =
color=3D"#000000"><font face=3D"verdana, sans-serif"> | </font><a href=3D"h=
ttp://edbpostgres.com" target=3D"_blank"><font face=3D"arial, sans-serif" c=
olor=3D"#000000"><b>edbpostgres.com</b></font></a></font></div><div><font c=
olor=3D"#38761d" size=3D"1"><font face=3D"arial, sans-serif">&quot;Don&#39;=
t Complain about Heat, Plant a TREE&quot;</font></font></div></div></div></=
div></div></div></div></div></div>

--000000000000191a4905aeb6b28c--

--000000000000191a4b05aeb6b28e
Content-Type: application/octet-stream; name="RM5794.patch"
Content-Disposition: attachment; filename="RM5794.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_kesdu6dc0>
X-Attachment-Id: f_kesdu6dc0

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Rhc2hib2FyZC9zdGF0aWMvanMvR3JhcGhzLmpzeCBi
L3dlYi9wZ2FkbWluL2Rhc2hib2FyZC9zdGF0aWMvanMvR3JhcGhzLmpzeAppbmRleCBhYzFjMTYw
NWYuLjQzMzMzZmU3MSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vZGFzaGJvYXJkL3N0YXRpYy9q
cy9HcmFwaHMuanN4CisrKyBiL3dlYi9wZ2FkbWluL2Rhc2hib2FyZC9zdGF0aWMvanMvR3JhcGhz
LmpzeApAQCAtODIsMjEgKzgyLDE0IEBAIGV4cG9ydCBmdW5jdGlvbiBzdGF0c1JlZHVjZXIoc3Rh
dGUsIGFjdGlvbikgewogICB9CiAKICAgT2JqZWN0LmtleXMoYWN0aW9uLmluY29taW5nKS5mb3JF
YWNoKGxhYmVsID0+IHsKLSAgICBpZihzdGF0ZVtsYWJlbF0pIHsKLSAgICAgIGlmKHN0YXRlW2xh
YmVsXS5sZW5ndGggPj0gWF9BWElTX0xFTkdUSCkgewotICAgICAgICBzdGF0ZVtsYWJlbF0udW5z
aGlmdCgpOwotICAgICAgfQotICAgICAgbmV3U3RhdGVbbGFiZWxdID0gWwotICAgICAgICBhY3Rp
b24uY291bnRlciA/ICBhY3Rpb24uaW5jb21pbmdbbGFiZWxdIC0gYWN0aW9uLmNvdW50ZXJEYXRh
W2xhYmVsXSA6IGFjdGlvbi5pbmNvbWluZ1tsYWJlbF0sCi0gICAgICAgIC4uLnN0YXRlW2xhYmVs
XSwKLSAgICAgIF07Ci0gICAgfSBlbHNlIHsKLSAgICAgIG5ld1N0YXRlW2xhYmVsXSA9IFsKLSAg
ICAgICAgYWN0aW9uLmNvdW50ZXIgPyAgYWN0aW9uLmluY29taW5nW2xhYmVsXSAtIGFjdGlvbi5j
b3VudGVyRGF0YVtsYWJlbF0gOiBhY3Rpb24uaW5jb21pbmdbbGFiZWxdLAotICAgICAgXTsKKyAg
ICBsZXQgbmV3RWxlID0gYWN0aW9uLmNvdW50ZXIgPyAgYWN0aW9uLmluY29taW5nW2xhYmVsXSAt
IGFjdGlvbi5jb3VudGVyRGF0YVtsYWJlbF0gOiBhY3Rpb24uaW5jb21pbmdbbGFiZWxdOworICAg
IHN0YXRlW2xhYmVsXSA9IHN0YXRlW2xhYmVsXSB8fCBbXTsKKyAgICBpZihzdGF0ZVtsYWJlbF0u
bGVuZ3RoID49IFhfQVhJU19MRU5HVEgpIHsKKyAgICAgIHN0YXRlW2xhYmVsXS5wb3AoKTsKICAg
ICB9CisgICAgc3RhdGVbbGFiZWxdLnVuc2hpZnQobmV3RWxlKTsKICAgfSk7Ci0gIHJldHVybiBu
ZXdTdGF0ZTsKKyAgcmV0dXJuIHN0YXRlOwogfQogCiBjb25zdCBjaGFydHNEZWZhdWx0ID0gewpA
QCAtMjYzLDYgKzI1Niw3IEBAIGV4cG9ydCBmdW5jdGlvbiBHcmFwaHNXcmFwcGVyKHByb3BzKSB7
CiAgIGNvbnN0IHRvU3RhdHNMZWdlbmRSZWYgPSB1c2VSZWYoKTsKICAgY29uc3QgYmlvU3RhdHNM
ZWdlbmRSZWYgPSB1c2VSZWYoKTsKICAgY29uc3Qgb3B0aW9ucyA9IHVzZU1lbW8oKCk9Pih7Cisg
ICAgbm9ybWFsaXplZDogdHJ1ZSwKICAgICBsZWdlbmRDYWxsYmFjazogbGVnZW5kQ2FsbGJhY2ss
CiAgICAgYW5pbWF0aW9uOiB7CiAgICAgICBkdXJhdGlvbjogMCwKQEAgLTM4NSw0ICszNzksNCBA
QCBHcmFwaHNXcmFwcGVyLnByb3BUeXBlcyA9IHsKICAgc2hvd1Rvb2x0aXA6IFByb3BUeXBlcy5i
b29sLmlzUmVxdWlyZWQsCiAgIHNob3dEYXRhUG9pbnRzOiBQcm9wVHlwZXMuYm9vbC5pc1JlcXVp
cmVkLAogICBpc0RhdGFiYXNlOiBQcm9wVHlwZXMuYm9vbC5pc1JlcXVpcmVkLAotfTsKXCBObyBu
ZXdsaW5lIGF0IGVuZCBvZiBmaWxlCit9Owo=
--000000000000191a4b05aeb6b28e--