"David G. Johnston" <david.g.johnston@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