Postgresqlのチューニング

[nakkaa]

• ALTER SYSTEM SET log_autovacuum_min_duration = '30s';
• ALTER SYSTEM SET autovacuum_vacuum_cost_limit = 1500;
• ALTER SYSTEM SET wal_buffers = '16MB';
• ALTER SYSTEM SET shared_buffers = '512MB';
• ALTER SYSTEM SET effective_cache_size = '1536MB';
• ALTER SYSTEM SET work_mem = '4MB';
• ALTER SYSTEM SET maintenance_work_mem = '128MB';
• ALTER SYSTEM SET max_connections = '30';

              name               | unit | setting 
---------------------------------+------+---------
 autovacuum_analyze_scale_factor |      | 0.05
 autovacuum_vacuum_cost_limit    |      | 1500
 autovacuum_vacuum_scale_factor  |      | 0.05
 checkpoint_completion_target    |      | 0.9
 default_statistics_target       |      | 100
 effective_cache_size            | 8kB  | 196608
 effective_io_concurrency        |      | 100
 full_page_writes                |      | on
 huge_pages                      |      | off
 maintenance_work_mem            | kB   | 131072
 max_connections                 |      | 30
 max_wal_size                    | MB   | 1024
 min_wal_size                    | MB   | 256
 random_page_cost                |      | 1.1
 shared_buffers                  | 8kB  | 65536
 synchronous_commit              |      | on
 wal_buffers                     | 8kB  | 2048
 work_mem                        | kB   | 4096
(18 rows)

とりあえずこれで。