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.