Skip to content

Instantly share code, notes, and snippets.

@pnorman

pnorman/tuning.sql

Created February 20, 2019 17:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pnorman/3120cef654b93ae1765306b658d5a1ae to your computer and use it in GitHub Desktop.
Save pnorman/3120cef654b93ae1765306b658d5a1ae to your computer and use it in GitHub Desktop.
Download ZIP
tuning
Raw
tuning.sql
ALSTER SYSTEM SET work_mem = '128MB';
ALSTER SYSTEM SET maintenance_work_mem = '4GB';
ALSTER SYSTEM SET default_statistics_target = '10000';
ALSTER SYSTEM SET autovacuum_vacuum_scale_factor = '0.05';
ALSTER SYSTEM SET autovacuum_analyze_scale_factor = '0.02';
ALSTER SYSTEM SET shared_buffers = '8GB';
ALSTER SYSTEM SET max_wal_size = '4GB';
ALSTER SYSTEM SET min_wal_size = '1GB';
ALSTER SYSTEM SET checkpoint_completion_target = '0.9';
ALSTER SYSTEM SET max_worker_processes = '10';
ALSTER SYSTEM SET max_parallel_workers_per_gather = '8';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment