"David G. Johnston" <david.g.johns...@gmail.com> writes: > The ANALYZE option should not be part of the GUC setup.
Yeah. While I'm generally not in favor of putting GUCs into the mix here, the only one that seriously scares me is a GUC that would affect whether the EXPLAIN'd query executes or not. A GUC that causes buffer counts to be reported/not-reported is not going to result in data destruction when someone forgets that it's on. (BTW, adding an option for auto-rollback wouldn't change my opinion about that. Not all side-effects of a query can be rolled back. Thus, if there is an auto-rollback option, it mustn't be GUC-adjustable either.) regards, tom lane