Re: Unlogged tables cleanup

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Unlogged tables cleanup
Дата
Msg-id CAB7nPqTfpSDVoFDKKVk-4vVnA4pqZw7hcXQnA9XYA3HdKRsi8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unlogged tables cleanup  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Unlogged tables cleanup
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Floating point comparison inconsistencies of the geometric types