\set ECHO none \pset format unaligned SELECT prob_cache_reset(); -- Both settings default to 'auto': a method called by name runs as named, -- touching neither the cache nor the fold. SHOW provsql.prob_cache; SHOW provsql.idp_fold; -- 'on' extends them to a method called by name, which makes the cache -- deterministic to exercise: no chooser decides what runs. SET provsql.prob_cache = on; SET provsql.idp_fold = off; CREATE TABLE city_lineage AS SELECT city, provenance() AS lin FROM (SELECT DISTINCT city FROM personnel) t; SELECT remove_provenance('city_lineage'); SELECT city, circuit_canonical_form(lin) AS kappa FROM city_lineage ORDER BY city; CREATE TABLE exc_lineage AS SELECT city, provenance() AS lin FROM (SELECT DISTINCT city FROM personnel EXCEPT SELECT p1.city FROM personnel p1, personnel p2 WHERE p1.id