Re: Parallell hashjoin sometimes ignores temp_tablespaces - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Parallell hashjoin sometimes ignores temp_tablespaces
Date
Msg-id CABUevExdx0qwZxcL3rPx=0mfaDd-aiqB5i2V-pkSRwhr=OKvRQ@mail.gmail.com
Whole thread Raw
Responses Re: Parallell hashjoin sometimes ignores temp_tablespaces  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers


On Mon, Jun 29, 2020 at 10:26 PM Daniel Gustafsson <daniel@yesql.se> wrote:
> On 29 Jun 2020, at 17:02, Magnus Hagander <magnus@hagander.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!
 
--

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum
Next
From: Tom Lane
Date:
Subject: Re: Missing "Up" navigation link between parts and doc root?