Re: [GENERAL] Estimated rows question

2012-09-01 Thread Tom Lane
[ sorry for slow response, but I'd not gotten time to think about this... ] Sam Ross ellip...@gmail.com writes: I was wondering why it seems that the query planner can't see, based on the histograms, that two join-columns have a very small intersection, and adjust its row estimation

[GENERAL] Estimated rows question

2012-08-21 Thread Sam Ross
I was wondering why it seems that the query planner can't see, based on the histograms, that two join-columns have a very small intersection, and adjust its row estimation accordingly. Clearly the below query returns 1001 rows. It appears as if much or all of the necessary machinery exists in