All the knobs for query planning and cost estimation can be scoped to the transaction with `set local <key>=<value>`.