On Wed, 20 Nov 2024 at 13:13, Greg Sabino Mullane <htamf...@gmail.com> wrote: >> It defaults to <literal>TRUE</literal> when <literal>ANALYZE</literal> is >> also enabled. Otherwise, it defaults to <literal>FALSE</literal>. > > Is that second sentence really needed? Because "BUFFERS ON" will never be > needed anymore (save as a no-op to allow the same explain queries to run > cross-version), and BUFFERS OFF outside of analyze is meaningless.
"BUFFERS ON" will be needed if the user wants to see the buffer usage in the planner when ANALYZE isn't specified. You'll see the planner access buffers when the caches are not fully populated and for get_actual_variable_range() work. Maybe the wording could just be based on the wording for the SUMMARY option, i.e. "Summary information is included by default when ANALYZE is used but otherwise is not included by default". David
