News for hackers. Stuff that matters.
Re:450× Faster Joins with Index Condition Pushdown by jmalicki on Saturday August 23, 2025 @06:13PM (#44999548)
Without storing the joint distribution of the values corresponding to the conditions that span multiple tables, it can be hard to know what's a win.
Re:450× Faster Joins with Index Condition Pushdown by Seattle3503 on Saturday August 23, 2025 @10:53PM (#45000902)
Postgres by default computes univariate stats for each column and uses those. If this is producing bad query plans, you can extend the statistics to be multivariate for select groups of columns manually. But to avoid combinatorially growth of stats related storage and work, you have to pick the columns by hand.
Re:450× Faster Joins with Index Condition Pushdown by jmalicki on Sunday August 24, 2025 @12:29PM (#45005538)
That still isn't multivariate stats across a join.