Hi, On 03/22/2016 01:46 PM, Tatsuo Ishii wrote: ...
Sorry, maybe I did not explain clearly. My question is, if put patches only 0002 to 0005 into 9.6, does it still give any visible benefit to users?
The users will be able to define statistics with the limitation that only a single one (the one covering the most columns referenced by the clauses) can be used when estimating a query. Which is not perfect, but I think it's a valuable improvement.
It might also be possible to split 0006 into smaller pieces, for example implementing the "non-overlapping statistics" case first and then extending it to more complicated cases. That might increase the change of getting at least some of that into 9.6 ...
But considering it's not clear whether the initial chunks are likely to make it into 9.6 - I kinda expect a fair amount of comments from TL about the preceding parts, who mentioned he might look at the patch this week. So I'm not sure splitting 0006 into smaller pieces makes sense at this point.
regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
