Module: PgHero::Methods::Settings

Included in:
Database
Defined in:
lib/pghero/methods/settings.rb

Instance Method Summary collapse

Instance Method Details

#autovacuum_settingsObject



29
30
31
# File 'lib/pghero/methods/settings.rb', line 29

def autovacuum_settings
  fetch_settings %i(autovacuum autovacuum_max_workers autovacuum_vacuum_cost_limit autovacuum_vacuum_scale_factor autovacuum_analyze_scale_factor)
end

#settingsObject



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
# File 'lib/pghero/methods/settings.rb', line 4

def settings
  names =
    if server_version_num >= 100000
      %i(
        max_connections shared_buffers effective_cache_size maintenance_work_mem
        checkpoint_completion_target wal_buffers default_statistics_target
        random_page_cost effective_io_concurrency work_mem huge_pages
        min_wal_size max_wal_size
      )
    elsif server_version_num >= 90500
      %i(
        max_connections shared_buffers effective_cache_size work_mem
        maintenance_work_mem min_wal_size max_wal_size checkpoint_completion_target
        wal_buffers default_statistics_target
      )
    else
      %i(
        max_connections shared_buffers effective_cache_size work_mem
        maintenance_work_mem checkpoint_segments checkpoint_completion_target
        wal_buffers default_statistics_target
      )
    end
  fetch_settings(names)
end

#vacuum_settingsObject



33
34
35
# File 'lib/pghero/methods/settings.rb', line 33

def vacuum_settings
  fetch_settings %i(vacuum_cost_limit)
end