SmartSearch performance tuning
SmartSearch::createFiltersTable(): materialize children ids For some reasons postgresql can not come with sane execution plans when combining get_children() (even when "with materialized"!) with other filters. Creating an explicit temporary table helps.