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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx> 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?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux