Re: Unlogged tables cleanup - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Unlogged tables cleanup
Date
Msg-id CAB7nPqTfpSDVoFDKKVk-4vVnA4pqZw7hcXQnA9XYA3HdKRsi8g@mail.gmail.com
Whole thread Raw
In response to Re: Unlogged tables cleanup  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Unlogged tables cleanup
List pgsql-hackers
On Thu, Nov 10, 2016 at 5:15 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> Okay, so what happens is that the CREATE TABLESPACE record removes the
> tablespace directory and recreates a fresh one, but as no CREATE
> records are created for unlogged tables the init fork is not
> re-created. It seems to me that we should log a record to recreate the
> INIT fork, and that heap_create_with_catalog() is missing something.
> Generating a record in RelationCreateStorage() is the more direct way,
> and that actually fixes the issue. Now the comments at the top of it
> mention that RelationCreateStorage() should only be used to create the
> MAIN forknum. So, wouldn't a correct fix be to log this INIT record at
> the end of heap_create()?

Nah. Looking at the code the fix is quite obvious.
heap_create_init_fork() is checking for XLogIsNeeded() to decide if
the INIT forknum should be logged or not. But this is wrong, it needs
to be done unconditionally to ensure that the relation gets created at
replay.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Floating point comparison inconsistencies of the geometric types