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--