On Fri, 2022-03-25 at 14:07 +, Kumar, Mukesh wrote:
> > [recommendation to fix the estimate]
> >
> > Perhaps it is also enough to blindly disable nested loop joins for the
> > whole query,
> > rather than doing the right thing and fixing the estimates:
> >
> > BEGIN;
> > SET LOCAL enable_nest
On Thu, 2022-03-24 at 15:59 +, Kumar, Mukesh wrote:
> We have recently migrated from Oracle to PostgreSQL on version 11.4 on azure
> postgres PaaS instance.
>
> There is 1 query which is taking approx. 10 secs in Oracle and when we ran
> the same query it is taking approx. 1 min
>
> Can a
On Thu, Mar 24, 2022 at 03:59:54PM +, Kumar, Mukesh wrote:
> Can anyone suggest to improve the query as from application end 1 min time is
> not accepted by client.
> Please find the query and explain analyze report from below link
It's hard to say for sure without seeing real query (query on
Hi,
1. Have you tried creating indexes on columns for which it is showing
sequential scans?
2. In my experience if the view is referring some other view inside it, it
is advisable to directly query on tables instead on child view.
3. This table 'so_vendor_address_base' definitely needs indexing to
Hi Team and All ,
Greeting for the day.
We have recently migrated from Oracle to PostgreSQL on version 11.4 on azure
postgres PaaS instance.
There is 1 query which is taking approx. 10 secs in Oracle and when we ran the
same query it is taking approx. 1 min
Can anyone suggest to improve the q
