Roger Hunwicks <roger@xxxxxxxxxxxxxxxxxxx> writes: > ... > However, even though we have similar performance for 12.4 for most > test runs, it remains very variable. > ... > I think we have narrowed down the problem to a single, very complex, > materialized view using CTEs; the unit tests create the test data and > then refresh the materialized view before executing the actual test > code. In addition to others' nearby comments, I'd suggest that running all this under auto_explain would be informative. You evidently are not getting a stable plan for your troublesome query, so you need to see what the range of plans is, not just probe it once with a manual EXPLAIN. regards, tom lane
