deeejay

psql - Query perf tuning

Aug 7th, 2014
399
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. show cpu_index_tuple_cost; -- Result: 0.005
  2. set cpu_index_tuple_cost = 0.0005 -- How fast a cpu grabs a row. Set before a query
  3.  
  4. show random_page_cost; -- Result: 4
  5. set random_page_cost = 2; -- Can improve ratio by half. Set before a query
Advertisement
Add Comment
Please, Sign In to add comment