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

[PERFORM] Query optimizer plans with very small selectivity estimates

2015-10-29 Thread Matthew Bellew
This related to a post in the general bugs forum, but I found this forum, and this seems more appropriate. This is my second attempt to post, I believe the first attempt last week did not work, apologies if I'm duplicating. http://comments.gmane.org/gmane.comp.db.postgresql.bugs/39011 I made ha