On Sat, 29 Dec 2018 at 20:15, Justin Pryzby wrote:
> On Sat, Dec 29, 2018 at 07:58:28PM +1300, David Rowley wrote:
> > Unfortunately, I don't think that'll help this situation. Extended
> > statistics are currently only handled for base quals, not join quals.
> > See dependency_is_compatible_claus
On Sat, Dec 29, 2018 at 1:58 AM David Rowley
wrote:
> On Sat, 29 Dec 2018 at 04:32, Justin Pryzby wrote:
> > I think the solution is to upgrade (at least) to PG10 and CREATE
> STATISTICS
> > (dependencies).
>
> Unfortunately, I don't think that'll help this situation. Extended
> statistics are c
On Sat, Dec 29, 2018 at 7:17 AM Jim Finnerty wrote:
> Jeff, can you describe the changes that were made to ANALYZE in v11,
> please?
>
> I've found that running ANALYZE on v10 on the Join Order Benchmark, using
> the default statistics target of 100, produces quite unstable results, so
> I'd be
