Page 1 of 1

PSQL config - default_statistics_target

PostPosted: Sun Aug 14, 2011 2:39 pm
by kydechuk01
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

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.

Re: PSQL config - default_statistics_target

PostPosted: Sun Aug 14, 2011 2:44 pm
by kraada
I don't believe that changing this value will make any significant improvements to PT3. But I'll add it to my list of things to make sure gets tested just to be certain.

Re: PSQL config - default_statistics_target

PostPosted: Sun Aug 14, 2011 2:50 pm
by kydechuk01
Thank you!

highfalutin