Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.

On Sat, Apr 3, 2021 at 09:00:24PM +0530, aditya desai wrote:
> adding the group.

Perfect. That is a lot of non-default settings, so I would be concerned
there are other misconfigurations in there --- the group here might have
some tips.

>  aad_log_min_messages                  | warning                               
>                       | configuration file

The above is not a PG config variable.

>  connection_ID                         | 5b59f092-444c-49df-b5d6-a7a0028a7855 
>                        | client
>  connection_PeerIP                     | fd40:4d4a:11:5067:6d11:500:a07:5144   
>                       | client
>  connection_Vnet                       | on                                   

Uh, these are not a PG settings. You need to show us the output of
version() because this is not standard Postgres. A quick search
suggests this is a Microsoft version of Postgres. I will stop
commenting.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.