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 aditya desai
Subject Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Date
Msg-id CAN0SRDHd5+vVGUT=5XHnag4mPkyZtMFpVFDzzi8+tA4F6Fwd0g@mail.gmail.com
Whole thread Raw
In response to Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (Michael Lewis <mlewis@entrata.com>)
Responses Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-performance
Tree view
Hi Michael,
Thanks for your response.
Is this table partitioned? - No
How long ago was migration done? - 27th March 2021
Has vacuum freeze and analyze of tables been done? - We ran vacuum analyze.
 Was index created after populating data or reindexed after perhaps? - Index was created after data load and reindex was executed on all tables yesterday.
 Version is PostgreSQL-11

Regards,
Aditya.


On Sat, Apr 3, 2021 at 7:40 PM Michael Lewis <mlewis@entrata.com> wrote:
It seems like something is missing. Is this table partitioned? How long ago was migration done? Has vacuum freeze and analyze of tables been done? Was index created after populating data or reindexed after perhaps? What version are you using?

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
Next
From: Bruce Momjian
Date:
Subject: Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.