Re: Oracle To Community Postgresql Migration
Julien Rouhaud <[email protected]> Tue, 14 Jan 2020 08:57:36 +0100
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CAOBaU_YeuS8DWvBnBa_T4HmQMeik_yf+Y1uPRUQZiSg-jnDo0w@mail.gmail.com> |
Hi, On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <[email protected]> wrote: > > 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. This is not a bug, you should rather use the pgsql-performance mailing list (https://www.postgresql.org/list/pgsql-performance/). When you'll do so, please also refer to https://wiki.postgresql.org/wiki/Slow_Query_Questions to provide enough information.