Re: Query Slow After 2018

2018-01-28 Thread David G. Johnston
On Sunday, January 28, 2018, Nur Agus wrote: > > Is this a bug on postgres-9.4.4 ? > > We are considering upgrade to postgres-10 but since this is a very > critical system, it takes a lot of test and approval :) > > Upgrade to 9.4.15. Asking if 9.4.4 might have a bug is a question most people h

Re: Query Slow After 2018

2018-01-28 Thread Justin Pryzby
On Mon, Jan 29, 2018 at 12:32:59AM +0700, Nur Agus wrote: > The following query run in just 9 ms: > "distrib_reports"."month" = 1 AND > "distrib_reports"."year" = 2017 AND > "distrib_reports"."state" = 'SUBMITTED' AND > "distrib_report_groups"."distrib_report_group_type_id" = > '559a5fdc-418d-