Re: base backup vs. concurrent truncation

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: base backup vs. concurrent truncation
Дата
Msg-id CA+TgmoZop14dZoN0v017jAQDD+cfSqYAG_mFSWhw_mxF8Sx=0A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: base backup vs. concurrent truncation  (Andres Freund <andres@anarazel.de>)
Ответы Re: base backup vs. concurrent truncation  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Mon, Apr 24, 2023 at 8:03 PM Andres Freund <andres@anarazel.de> wrote:
> What we've discussed somewhere in the past is to always truncate N+1 when
> creating the first page in N. I.e. if we extend into 23456.1, we truncate
> 23456.2 to 0 blocks.  As far as I can tell, that'd solve this issue?

Yeah, although leaving 23456.2 forever unless and until that happens
doesn't sound amazing.

--
Robert Haas
EDB: http://www.enterprisedb.com



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: enhancing plpgsql debug api - hooks on statements errors and function errors
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Orphaned wait event