Re: [GENERAL] workaround for column cross-correlation

2017-06-12 Thread Justin Pryzby
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

Re: [GENERAL] workaround for column cross-correlation

2017-06-12 Thread Jeff Janes
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?)