Re: [PERFORM] join estimate of subqueries with range conditions and constraint exclusion

2017-06-03 Thread David G. Johnston
On Wed, May 24, 2017 at 2:17 PM, Justin Pryzby wrote: > We got bitten again by what appears to be the same issue I reported > (perhaps > poorly) here: > https://www.postgresql.org/message-id/20170326193344. > GS31628%40telsasoft.com > > We have PG9.6.3 table heirarchies

[PERFORM] join estimate of subqueries with range conditions and constraint exclusion

2017-05-24 Thread Justin Pryzby
We got bitten again by what appears to be the same issue I reported (perhaps poorly) here: https://www.postgresql.org/message-id/20170326193344.GS31628%40telsasoft.com We have PG9.6.3 table heirarchies partitioned by time. Our reports use subqueries each with their own copies of a range clauses