Performance Issue after upgrade from 9 to 11

From: Perumal Raj <perucinci(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Performance Issue after upgrade from 9 to 11
Date: 2020-01-29 17:39:03
Message-ID: CALvqh4rB4a71Cw+YiJ42PKaCrw7gDKzjyOgbZ4eMWTQmmVtoog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-01-29 18:20:36 Re: Performance Issue after upgrade from 9 to 11
Previous Message Achilleas Mantzios 2020-01-29 16:12:20 Exclude constraint on ranges : commutative containment : allow only complete containment