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?

  • Child tables does not affect each other but all affect main table.So your main table will be locked.I haven't used but there is and extension called pg_repack. I think you are searching for it. reorg.github.io/pg_repack – Yavuz Selim Dec 27 '18 at 13:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.