On Sun, Apr 14, 2019 at 11:59:45PM -0400, Gunther wrote:
> On 4/14/2019 23:24, Tom Lane wrote:
> >Any chance of extracting a self-contained test case that reproduces this?
> With 18 million rows involved in the base tables, hardly.
Were you able to reproduce the problem with SELECT (without INSERT) ?
How many rows does it output ? Show explain analyze if possible. If that
still errors, can you make it work with a small enough LIMIT ?
We haven't seen the view - maybe it's very complicated, but can you reproduce
with a simpler one ? Fewer joins ? Or fewer join conditions ?
Justin