Performance Issue after upgrade from 9 to 11

[Perumal Raj <perucinci@xxxxxxxxx>]

Hi All,

We have recently upgraded postgres from 9.2 to 11.6 and started seeing performance issue immediately and  able to fix the performance issue after disabling parameter: enable_seqscan.

Question : 

Should i keep the above parameter always disabled ? If not why the behavior changed in Higher version ?

Note:

Table ANALYZE completed as part of Upgrade activity.

Thanks

Raj