Re: Parallell hashjoin sometimes ignores temp_tablespaces

On Mon, Jun 29, 2020 at 10:26 PM Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> > On 29 Jun 2020, at 17:02, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
> > I think the fix is the attached one (tested on version 11 which is what
> $customer is using). To me it looks like this may have been a copy/paste
> error all the way back in 98e8b480532 which added default_tablespace back
> in 2004. (And is in itself entirely unrelated to parallel hashjoin, but
> that's where it got exposed at least in my case)
>
> Running through the repro and patch on HEAD I confirm that the attached
> fixes
> the issue. +1 for the patch and a backpatch of it.
>
> It would be nice to have a test covering test_tablespaces, but it seems a
> tad
> cumbersome to create a stable one.
>

Thanks. pushed!

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>