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 <mle...@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? >
