Search code examples
postgresqlsettingspg

Max_wal_size setting value is not currect from the pg_settings


I found that select setting from pg_settings where name = 'max_wal_size' and show max_wal_size the value is different in postgresql-9.6.6 .The value return from show max_wal_size is the same as the postgresql.conf what I had set . I did not run the alter system command to change the max_wal_size in the command line .I'v check the pg_settings the max_wal_size which source is postgresql.conf.Is there some difference between these two command ? Where can I find which value is activated in postgresql?


Solution

  • The value from the view pg_settings should be the setting * unit.And the value equal the value from show max_wal_size