Re: Oracle To Community Postgresql Migration

--000000000000c5da6f059c195c3b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=C3=BAt 14. 1. 2020 v 13:54 odes=C3=ADlatel Vijay Ingle <[email protected]=
om> 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 <[email protected]> wrote:
>
>> 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 take=
n
>> 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.
>>
>

--000000000000c5da6f059c195c3b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">=C3=BAt 14. 1. 2020 v=C2=A013:54 odes=
=C3=ADlatel Vijay Ingle &lt;<a href=3D"mailto:[email protected]">vjingle=
[email protected]</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"auto">Hi,<div dir=3D"auto">Thnx for support,</div=
><div dir=3D"auto">But as checked, in one table having 60k records , but wh=
enever i fire query select query it will taking 20 sec for output.</div></d=
iv></blockquote><div><br></div><div>please, again <a href=3D"https://wiki.p=
ostgresql.org/wiki/Slow_Query_Questions">https://wiki.postgresql.org/wiki/S=
low_Query_Questions</a></div><div><br></div><div>Regards</div><div><br></di=
v><div>Pavel<br> </div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><b=
r><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, =
Jan 14, 2020, 1:27 PM Julien Rouhaud &lt;<a href=3D"mailto:[email protected]=
om" target=3D"_blank">[email protected]</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Tue, Jan 14, 2020 at 8:52 AM Vijay Ingle &lt;<a href=3D"mailto:vjingle14=
[email protected]" rel=3D"noreferrer" target=3D"_blank">[email protected]</a>&=
gt; wrote:<br>
&gt;<br>
&gt; We are getting slowness after migration from oracle to Postgresql.<br>
&gt; As checked in oracle function executed within 2 sec but same code take=
n time in Postgresql.<br>
&gt; Index already applied, constraints already applied.<br>
&gt; All configuration parameters was ok.<br>
&gt; Cpu memory utilization everything was ok.<br>
&gt; Please suggest what we should do.<br>
<br>
This is not a bug, you should rather use the pgsql-performance mailing<br>
list (<a href=3D"https://www.postgresql.org/list/pgsql-performance/" rel=3D=
"noreferrer noreferrer" target=3D"_blank">https://www.postgresql.org/list/p=
gsql-performance/</a>).<br>
<br>
When you&#39;ll do so, please also refer to<br>
<a href=3D"https://wiki.postgresql.org/wiki/Slow_Query_Questions" rel=3D"no=
referrer noreferrer" target=3D"_blank">https://wiki.postgresql.org/wiki/Slo=
w_Query_Questions</a> to provide<br>
enough information.<br>
</blockquote></div>
</blockquote></div></div>

--000000000000c5da6f059c195c3b--