Re: Oracle To Community Postgresql Migration
| От | Vijay Ingle |
|---|---|
| Тема | Re: Oracle To Community Postgresql Migration |
| Дата | |
| Msg-id | CAPpGjEmgUc1RA0OEEN26QCLCnAxWdtmeqLBmJrrU0wPRy5kbyQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Oracle To Community Postgresql Migration (Julien Rouhaud <rjuju123@gmail.com>) |
| Ответы |
Re: Oracle To Community Postgresql Migration
|
| Список | pgsql-bugs |
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 <rjuju123@gmail.com> wrote:
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 по дате отправления: