| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Vijay Ingle <vjingle143(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Oracle To Community Postgresql Migration |
| Date: | 2020-01-14 07:57:36 |
| Message-ID: | CAOBaU_YeuS8DWvBnBa_T4HmQMeik_yf+Y1uPRUQZiSg-jnDo0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <vjingle143(at)gmail(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-01-14 08:47:09 | Re: REINDEX CONCURRENTLY unexpectedly fails |
| Previous Message | Vijay Ingle | 2020-01-14 07:52:03 | Oracle To Community Postgresql Migration |