Re: Shouldn't we have a way to avoid "risky" plans?
From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Josh Berkus <josh(at)agliodbs(dot)com>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Claudio Freire <klaussfreire(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject:
Re: Shouldn't we have a way to avoid "risky" plans?
On Apr 19, 2011, at 9:50 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote: > For example, on very large tables I've been known to set > analyze_scale_factor to 0 and analyze_threshold to 5000.