Re: Too slow to create new schema and their tables, functions,triggers.

Running that sql:

name    setting
autovacuum    on
autovacuum_analyze_scale_factor    0.1
autovacuum_analyze_threshold    50
autovacuum_freeze_max_age    200000000
autovacuum_max_workers    3
autovacuum_multixact_freeze_max_age    400000000
autovacuum_naptime    60
autovacuum_vacuum_cost_delay    20
autovacuum_vacuum_cost_limit    -1
autovacuum_vacuum_scale_factor    0.2
autovacuum_vacuum_threshold    50
autovacuum_work_mem    -1




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html