Postgres Pro
Downloads
Home   >   mailing lists

Performance Issue after upgrade from 9 to 11 - Mailing list pgsql-general

From Perumal Raj
Subject Performance Issue after upgrade from 9 to 11
Date
Msg-id CALvqh4rB4a71Cw+YiJ42PKaCrw7gDKzjyOgbZ4eMWTQmmVtoog@mail.gmail.com
Whole thread Raw
Responses Re: Performance Issue after upgrade from 9 to 11
Re: Performance Issue after upgrade from 9 to 11
Re: Performance Issue after upgrade from 9 to 11
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Exclude constraint on ranges : commutative containment : allow onlycomplete containment
Next
From: Adrian Klaver
Date:
Subject: Re: Performance Issue after upgrade from 9 to 11