Re: Oracle To Community Postgresql Migration - Mailing list pgsql-bugs

From Julien Rouhaud
Subject Re: Oracle To Community Postgresql Migration
Date
Msg-id CAOBaU_YeuS8DWvBnBa_T4HmQMeik_yf+Y1uPRUQZiSg-jnDo0w@mail.gmail.com
Whole thread Raw
In response to Oracle To Community Postgresql Migration  (Vijay Ingle <vjingle143@gmail.com>)
Responses Re: Oracle To Community Postgresql Migration  (Vijay Ingle <vjingle143@gmail.com>)
List pgsql-bugs
Hi,

On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <vjingle143@gmail.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.



pgsql-bugs by date:

Previous
From: Vijay Ingle
Date:
Subject: Oracle To Community Postgresql Migration
Next
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY unexpectedly fails