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
