Re: Adaptive query optimization

Hello,
this seems very interesting and make me think about 2 other projets:
- https://github.com/trustly/pg_badplan
- https://github.com/ossc-db/pg_plan_advsr

As I understand all this, there are actually 3 steps:
- compare actual / estimated rows
- suggests some statistics gathering modification
- store optimised plans (or optimized stats) for reuse

I really like the "advisor Idea", permitting to identify where statistics
are wrong
and how to fix them with ANALYZE command.
Is there a chance that some futur Optimizer / statistics improvements
make thoses "statistics advices" enough to get good plans (without having to
store live stats
or optimized plan) ?

Thanks in advance
Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html