David Rowley <dgrowle...@gmail.com> writes: > For the record, I 100% agree that there will always be cases where > statistics are just unable to represent what is discovered at > run-time, so having some sort of ability to adapt at run-time seems > like a natural progression on the evolutionary chain. I just don't > know if it's the best or best next step to make. I suspect we might be > skipping a few steps from what we have now if we went there in the > near future. We don't yet have extended statistics for joins yet, for > example.
Yeah. There is plenty remaining to be done towards collecting and applying traditional sorts of statistics. I worry about ideas such as run-time plan changes because we will have exactly zero ability to predict what'll happen if the executor starts doing that. Maybe it'll be great, but what do you do if it isn't? regards, tom lane