RE: View taking time to show records

2022-03-26 Thread Kumar, Mukesh
Hi Albe , Thanks for the below suggestion , When I ran the query with the parameter , it is taking only 1 sec. So could you please let me know if I can put this parameter to OFF . at database and it will not create any issues to queries running in database. Could you please share some light

Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join

2022-03-26 Thread Tomas Vondra
On 3/22/22 13:57, Prajna Shetty wrote: > ++ _pgsql-performance@postgresql.org_ > >   > Hello Team, >   > There is change in query plan in 12.4 version and Version 13 resulting > in performance slowness post upgrade. >   > > * In 12.4 versio