Skip to main content
Tweeted twitter.com/StackDBAs/status/1111372557221941248
clean up
Source Link
Erwin Brandstetter
  • 182.1k
  • 28
  • 457
  • 620

According to documentation, for "min_wal_size" and "max_wal_size" parameters

defaultDefault values are, according to documentation for min_wal_size and max_wal_size parameters:

For max_wal_size: The default is 1 GB

For
For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? orOr what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB

Any help will be appreciated

According to documentation, for "min_wal_size" and "max_wal_size" parameters

default values are:

For max_wal_size: The default is 1 GB

For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB

Any help will be appreciated

Default values are, according to documentation for min_wal_size and max_wal_size parameters:

For max_wal_size: The default is 1 GB
For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? Or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB
added 28 characters in body
Source Link
Oto Shavadze
  • 545
  • 1
  • 7
  • 15

According to documentation, for "min_wal_size" and "max_wal_size" parameters

default values are:

For max_wal_size: The default is 1 GB

For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB

Any help will be appreciated

According to documentation, for "min_wal_size" and "max_wal_size" parameters

default values are:

For max_wal_size: The default is 1 GB

For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB

According to documentation, for "min_wal_size" and "max_wal_size" parameters

default values are:

For max_wal_size: The default is 1 GB

For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB

Any help will be appreciated

Source Link
Oto Shavadze
  • 545
  • 1
  • 7
  • 15

Understanding "max_wal_size" and "min_wal_size" parameters default values from postgresql.conf file

According to documentation, for "min_wal_size" and "max_wal_size" parameters

default values are:

For max_wal_size: The default is 1 GB

For min_wal_size: The default is 80 MB

Then I look this parameters from my database config:

select name, setting, unit 
from pg_settings 
where name in ('min_wal_size', 'max_wal_size')

Gives result:

name         |  setting | unit
----------------------------------
max_wal_size | 64       | 
min_wal_size | 5        |

I have 2 questions:

  1. Why these values doesn't match default values, which are shown in docs? I never changed config settings at all.

  2. Why unit column is empty/NULL for these parameters? What means 64 and 5 values in this case? MB? GB? or what?

Why this is not like for example work_mem parameter, when everything is clear:

name         | setting  | unit
----------------------------------
work_mem     | 4096     | kB