subject:"\[GENERAL\] Query Using Massive Temp Space"

Re: [GENERAL] Query Using Massive Temp Space

2017-11-21 Thread Tom Lane

Thomas Munro writes: > On Wed, Nov 22, 2017 at 7:04 AM, Tom Lane wrote: >> Now, there's definitely something busted here; it should not have gone as >> far as 2 million batches before giving up on splitting. > I had been meaning to discuss

Re: [GENERAL] Query Using Massive Temp Space

2017-11-20 Thread Cory Tucker

On Mon, Nov 20, 2017 at 9:36 AM Tom Lane wrote: > 9.6.what exactly? > 9.6.5 > > The only thing I can think of offhand that could create temp files far in > excess of the actual data volume is if a hash join repeatedly decides that > it needs to increase the number of hash