postgresql数据库调优

最新推荐文章于 2024-09-22 11:17:00 发布

晴天v1

最新推荐文章于 2024-09-22 11:17:00 发布

阅读量119

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/zhangyou1010/article/details/88348959

版权

/opt/PostgreSQL/9.1.3/data/vacuumdb -h 127.0.0.1 -p 5432 -U postgres -f -z -q -d aischool

max_connections = 1000

shared_buffers = 2048MB
work_mem = 2MB
maintenance_work_mem = 48MB
shared_preload_libraries = 'pg_stat_statements,auto_explain '
wal_buffers = 16384kB
checkpoint_segments = 30
random_page_cost = 2.0
effective_cache_size = 15938MB
log_min_duration_statement = 200ms
log_line_prefix = '%t %d'
log_statement = 'ddl'
track_activity_query_size = 4096
custom_variable_classes = 'pg_stat_statements,auto_explain '
pg_stat_statements.max = 10000
pg_stat_statements.track = all
auto_explain.log_min_duration = 1s