Does VACUUM FULL ANALYZE a partition locks the main table in postgresql?

2 votes

1 answer

1186 views

                          I'm using postgresql 9.5 and partman for partitioning tables.
there is this table that has 30 partitions and volume of one of them are too higher than others. so I need to full vacuum this partition but I don't  want to lock the main table.
is it possible?
                        

Asked by Alireza (123 rep)

Dec 22, 2018, 12:22 PM
Last activity: Jun 19, 2025, 12:04 PM

Does VACUUM FULL ANALYZE a partition locks the main table in postgresql?

Related Questions