PSQL config - default_statistics_target

[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.

[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.

[kydechuk01]

Thank you!