Skip to content

Review default and blockedlist postgresql.conf

StackGres includes both:

This issue calls for a deep review of both. In particular, among other suggestions, is proposed to:

  • Document all the parameters and their values in a table, and explain why each value is proposed.
  • Check for missing parameters. For example, we should set some sane defaults in pg_stat_statements.*, given we're including it by default.
  • Why the blockedlist only contains the blockedlist, and not the values we're setting by default? Should we include them all in the default list too? Are those in blockedlist not present in defaults using Postgres' own default values? This should be clarified.
  • Include final configurations in SG.
  • Apply changes required for 1.0.
Edited by Matteo Melli