Postgres Pro
Downloads
Home   >   mailing lists

Provide a pg_truncate_freespacemap function - Mailing list pgsql-hackers

From Ronan Dunklau
Subject Provide a pg_truncate_freespacemap function
Date
Msg-id 5446938.Sb9uPGUboI@aivenlaptop
Whole thread Raw
Responses Re: Provide a pg_truncate_freespacemap function
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: 'Alvaro Herrera'
Date:
Subject: Re: Some shared memory chunks are allocated even if related processes won't start
Next
From: Daniel Gustafsson
Date:
Subject: Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set