Re: Parallell hashjoin sometimes ignores temp_tablespaces

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Parallell hashjoin sometimes ignores temp_tablespaces
Date: 2020-06-29 20:26:23
Message-ID: ED9D511C-344D-4BE7-928E-DE246EF6F674@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.

cheers ./daniel

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-06-29 21:22:29 Re: Default setting for enable_hashagg_disk
Previous Message Tom Lane 2020-06-29 19:51:48 Re: [PATCH] Better cleanup in TLS tests for -13beta2