Re: [PERFORM] Query optimizer plans with very small selectivity estimates

2015-10-29 Thread Josh Berkus
On 10/29/2015 11:24 AM, Tom Lane wrote: > Matthew Bellew writes: >> I made have several users encounter performance problems, which all >> seem to come down to this problem: multiplying selectivity estimates can >> cause tuple estimates to grow very small very quickly, once the estimator >> gets t

Re: [PERFORM] Query optimizer plans with very small selectivity estimates

2015-10-29 Thread Tom Lane
Matthew Bellew writes: > I made have several users encounter performance problems, which all > seem to come down to this problem: multiplying selectivity estimates can > cause tuple estimates to grow very small very quickly, once the estimator > gets to 1 row, the planner may choose plans that are