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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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