From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Vijay Ingle <vjingle143(at)gmail(dot)com> |
Cc: | Julien Rouhaud <rjuju123(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Oracle To Community Postgresql Migration |
Date: | 2020-01-14 13:13:11 |
Message-ID: | CAFj8pRDivimJRoYk04M9BCdayzEUoQxcOE2rT7Awa7ZY=WEubg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
út 14. 1. 2020 v 13:54 odesílatel Vijay Ingle <vjingle143(at)gmail(dot)com> 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.
>
please, again https://wiki.postgresql.org/wiki/Slow_Query_Questions
Regards
Pavel
>
> On Tue, Jan 14, 2020, 1:27 PM Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
>
>> 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 | Heikki Linnakangas | 2020-01-14 21:41:11 | Re: REINDEX CONCURRENTLY unexpectedly fails |
Previous Message | Vijay Ingle | 2020-01-14 12:54:24 | Re: Oracle To Community Postgresql Migration |