Oracle To Community Postgresql Migration

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Oracle To Community Postgresql Migration

Vijay Ingle
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
Reply | Threaded
Open this post in threaded view
|

Re: Oracle To Community Postgresql Migration

Julien Rouhaud
Hi,

On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <[hidden email]> 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.


Reply | Threaded
Open this post in threaded view
|

Re: Oracle To Community Postgresql Migration

Vijay Ingle
Hi,
Thnx for support,
But as checked, in one table having 60k records , but whenever i fire query select query it will taking 20 sec for output.

On Tue, Jan 14, 2020, 1:27 PM Julien Rouhaud <[hidden email]> wrote:
Hi,

On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <[hidden email]> 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.
Reply | Threaded
Open this post in threaded view
|

Re: Oracle To Community Postgresql Migration

Pavel Stehule


út 14. 1. 2020 v 13:54 odesílatel Vijay Ingle <[hidden email]> napsal:
Hi,
Thnx for support,
But as checked, in one table having 60k records , but whenever i fire query select query it will taking 20 sec for output.


Regards

Pavel

On Tue, Jan 14, 2020, 1:27 PM Julien Rouhaud <[hidden email]> wrote:
Hi,

On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle <[hidden email]> 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.