> Easy first question: is the temp table analyzed before being used in a > join ?
No, I haven't done that. Today, I tried to run
ANALYZE records_to_filter_on;
on the same sample data set (3.75 million rows) before the join, and it did not
seem to make much of a difference in terms of time (new output of EXPLAIN
ANALYZE at https://explain.dalibo.com/plan/YZu - it seems very similar to me).
Not sure if it is relevant, but I did some experimentation with smaller
samples, and for those, there was a significant speedup. Could there be some
size threshold on the temp table after which running ANALYZE does not yield any
speedup?
> I think the attachment is missing.
Added now.
Simen
explain_analyze.json
Description: explain_analyze.json
pg_settings.conf
Description: pg_settings.conf
