Advertising:

Ver Salida del comando

From Zabbix-ES
Revision as of 14:22, 22 September 2020 by Unknown user (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
[VOLVER]
Using postgresql.conf at this path:/var/lib/pgsql/12/data/postgresql.conf

Is this correct? [(y)es/(n)o]: y
Writing backup to: /tmp/timescaledb_tune.backup202005261520
shared_preload_libraries needs to be updated
Current:
#shared_preload_libraries = 

Recommended:
shared_preload_libraries = 'timescaledb'

Is this okay? [(y)es/(n)o]: y
success: shared_preload_libraries will be updated
Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: y
Recommendations based on 23.37 GB of available memory and 32 CPUs for PostgreSQL 12

Memory settings recommendations
Current:
shared_buffers = 4GB
#effective_cache_size = 4GB
#maintenance_work_mem = 64MB
work_mem = 512MB

Recommended:
shared_buffers = 5982MB
effective_cache_size = 17946MB
maintenance_work_mem = 2047MB
work_mem = 1914kB

Is this okay? [(y)es/(s)kip/(q)uit]: y
success: memory settings will be updated
Parallelism settings recommendations
Current:
missing: timescaledb.max_background_workers
#max_worker_processes = 8
#max_parallel_workers_per_gather = 2
#max_parallel_workers = 8

Recommended:
timescaledb.max_background_workers = 8
max_worker_processes = 43
max_parallel_workers_per_gather = 16
max_parallel_workers = 32

Is this okay? [(y)es/(s)kip/(q)uit]: y
success: parallelism settings will be updated
WAL settings recommendations
Current:
#wal_buffers = -1
#min_wal_size = 80MB
max_wal_size = 2GB

Recommended:
wal_buffers = 16MB
min_wal_size = 512MB
max_wal_size = 1GB

Is this okay? [(y)es/(s)kip/(q)uit]: y
success: WAL settings will be updated
Miscellaneous settings recommendations
Current:
#default_statistics_target = 100
#random_page_cost = 4.0
#checkpoint_completion_target = 0.5
max_connections = 800
#max_locks_per_transaction = 64
#autovacuum_max_workers = 3
#autovacuum_naptime = 1min
#effective_io_concurrency = 1

Recommended:
default_statistics_target = 500
random_page_cost = 1.1
checkpoint_completion_target = 0.9
max_connections = 100
max_locks_per_transaction = 256
autovacuum_max_workers = 10
autovacuum_naptime = 10
effective_io_concurrency = 200

Is this okay? [(y)es/(s)kip/(q)uit]: y
success: miscellaneous settings will be updated
Saving changes to: /var/lib/pgsql/12/data/postgresql.conf
- Nosotros actualizamos el max_connections ya que sabemos que 100 es muy poco.
$ vi /var/lib/pgsql/12/data/postgresql.conf
  max_connections = 800


[VOLVER]