While doing DB operations on PostgreSQL pg_xlog_archive is consuming more than 150GB disk space with the option "archive_mode = on". How to cleanup/reduce pg_xlog_archive folder size.
What will happen if I disable "archive_mode= off". I have tried "off" option also but DB operations are taking too much time. How archive_mode do work?