On Thu, Oct 20, 2016 at 2:11 PM, Pavan Deolasee <pavan.deola...@gmail.com> wrote: > 4. Remove FSM and VM files for the affected tables (I don't think if it's > safe to do this on a running server)
Definitely not while the server is running... For VMs a good way would be to use pg_visibility's pg_truncate_visibility_map(), but only for 9.6~. For FSM there is no real solution, and actually a pg_truncate_fsm would prove to be useful here. So users would need to stop once the server if there are corrupted VMs or FSMs, delete them manually, and then run VACUUM to rebuild them. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers