Oracle To Community Postgresql Migration

Vijay Ingle <[email protected]> Tue, 14 Jan 2020 13:22:03 +0530
Newsgroups gmane.comp.db.postgresql.bugs
Message-ID <CAPpGjEnYca2vpHHSSRuNbCD812n8V_1vkm0qfkCfxwkgY1dCVg@mail.gmail.com>
--000000000000e43c38059c14dea5
Content-Type: text/plain; charset="UTF-8"

Hi Team,

We are getting slowness after migration from oracle to Postgresql.
As checked in oracle function executed within 2 sec but same code taken
time in Postgresql.
Index already applied, constraints already applied.
All configuration parameters was ok.
Cpu memory utilization everything was ok.
Please suggest what we should do.

Regards,
Vijay P Ingle

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

<div dir=3D"auto">Hi Team,<div dir=3D"auto"><br></div><div dir=3D"auto">We =
are getting slowness after migration from oracle to Postgresql.</div><div d=
ir=3D"auto">As checked in oracle function executed within 2 sec but same co=
de taken time in Postgresql.</div><div dir=3D"auto">Index already applied, =
constraints already applied.</div><div dir=3D"auto">All configuration param=
eters was ok.</div><div dir=3D"auto">Cpu memory utilization everything was =
ok.</div><div dir=3D"auto">Please suggest what we=C2=A0should do.</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto">V=
ijay P Ingle</div></div>

--000000000000e43c38059c14dea5--