Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Date
Msg-id 20210403153812.GE29125@momjian.us
Whole thread Raw
In response to Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Next
From: Tom Lane
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.