Thread: When to reload and when to restart?

Is there a list anywyere of what config changes take effect after a reload
and which after a restart?

Reading over a number of settings to optimize performance, but would like to
know what settings require restart.. other than trying to use show to see if
the change took effect.

Can all variables be seen from "show all" in psql?

Francisco Reyes <lists@stringsutils.com> writes:
> Is there a list anywyere of what config changes take effect after a reload
> and which after a restart?

These settings require a postmaster restart, nothing else does:
    select name from pg_settings where context = 'postmaster';

            regards, tom lane