On Mon, Jun 12, 2017 at 08:46:57PM -0700, Jeff Janes wrote:
> On Mon, Jun 12, 2017 at 8:17 PM, Justin Pryzby wrote:
>
> > I know PG 10 will have support "CREATE STATISTICS.." for this..
> >
> > ..but I wondered if there's a recommended workaround in earlier versions ?
>
> Not without seeing the
On Mon, Jun 12, 2017 at 8:17 PM, Justin Pryzby wrote:
> I know PG 10 will have support "CREATE STATISTICS.." for this..
>
> ..but I wondered if there's a recommended workaround in earlier versions ?
>
Not without seeing the query
>
> 2) memory explosion in hash join (due to poor estimate?)
I know PG 10 will have support "CREATE STATISTICS.." for this..
..but I wondered if there's a recommended workaround in earlier versions ?
We had two issues:
1) improper estimate caused poor plans (nested loops due to ::date, GROUP BY,
cross-column stats, and maybe more).
2) memory explosion in