deeejay icon

psql - Query perf tuning

deeejay | PRO | 08/07/14 07:35:12 PM UTC | 0 ⭐ | 349 👁️ | Never ⏰ | []
PostgreSQL |

240 B

|

None

|

0 👍

/

0 👎

show cpu_index_tuple_cost; -- Result: 0.005
set cpu_index_tuple_cost = 0.0005 -- How fast a cpu grabs a row. Set before a query
 
show random_page_cost; -- Result: 4
set random_page_cost = 2; -- Can improve ratio by half. Set before a query

Comments