Skip to content

Instantly share code, notes, and snippets.

@tqyq

tqyq/gist:ae28d4c8a1def9ddd663a21c0f4f88d3

Created July 11, 2017 09:35
Show Gist options
  • Save tqyq/ae28d4c8a1def9ddd663a21c0f4f88d3 to your computer and use it in GitHub Desktop.
Save tqyq/ae28d4c8a1def9ddd663a21c0f4f88d3 to your computer and use it in GitHub Desktop.
Download ZIP
postgresql optimize query parallel
Raw
gistfile1.txt
set max_worker_processes = 64;
set max_parallel_workers_per_gather = 16;
#设置强制并行，建议off，避免不必要的使用worker
#set force_parallel_mode = on;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment