On Fri, May 08, 2020 at 07:58:39AM -0400, Matt Daw wrote:
Hi Tomas, there’s an interesting related paper in the April 2020 PVLDB, “Quantifying TPC-H Choke Points and Their Optimizations”: http://www.vldb.org/pvldb/vol13/p1206-dreseler.pdf.
Thanks. Seems like an interesting and new paper, although it seems to focus more on execution than planning, i.e. it discusses execution strategies but not how to pick the right plan. E.g. the Q2 might also be rewritten to compute the whole subplan only once for all ps_partkey values, and then used for lookup (instead of running it over and over for each ps_partkey value). But this still depends on us being able to decide between those two strategies, which relies on good estimates :-( regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
