Provide a pg_truncate_freespacemap function

Поиск
Список
Период
Сортировка
От Ronan Dunklau
Тема Provide a pg_truncate_freespacemap function
Дата
Msg-id 5446938.Sb9uPGUboI@aivenlaptop
обсуждение исходный текст
Ответы Re: Provide a pg_truncate_freespacemap function  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Дерево обсуждения 
Hello,

As we are currently experiencing a FSM corruption issue [1], we need to 
rebuild FSM when we detect it. 

I noticed we have something to truncate a visibility map, but nothing for the 
freespace map, so I propose the attached (liberally copied from the VM 
counterpart) to allow to truncate a FSM without incurring downtime, as 
currently our only options are to either VACUUM FULL the table or stop the 
cluster and remove the FSM manually.

Does that seem correct ?


[1]  https://www.postgresql.org/message-id/flat/
1925490.taCxCBeP46%40aivenlaptop#7ace95c95cab17b6d92607e5362984ac

--
Ronan Dunklau
Вложения

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

Предыдущее
От: 'Alvaro Herrera'
Дата:
Сообщение: Re: Some shared memory chunks are allocated even if related processes won't start
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set