PSQL config - default_statistics_target
Posted: Sun Aug 14, 2011 2:39 pm
PostgreSQL config has this option, and in manuals it is said that this is used to improve Analyze process.
Larger values increase the time needed to do ANALYZE, but might improve the quality of the planner's estimates
Bigger values causes much more time for Analyzing base. For example if 100 then 2-3 min for Analyze of 6Gb (600k hands) base, if 500 - 20 min and so on. I'm using 500 now.
Will somebody tell, can we using this option really improve speed of afterwards PokerTrackers base search processes? By the cost of housekeeping time of course.
Larger values increase the time needed to do ANALYZE, but might improve the quality of the planner's estimates
- Code: Select all
# - Other Planner Options -
default_statistics_target = 100 # range 1-10000
Bigger values causes much more time for Analyzing base. For example if 100 then 2-3 min for Analyze of 6Gb (600k hands) base, if 500 - 20 min and so on. I'm using 500 now.
Will somebody tell, can we using this option really improve speed of afterwards PokerTrackers base search processes? By the cost of housekeeping time of course.