On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory.
From the storage-file-layout this directory contains multitransaction status data.
| pg_multixact | Subdirectory containing multitransaction status data (used for shared row locks) |
It would really help if someone can provide some reading material
regarding pg_multixact? Would this also result in database slowness by
any chance?
Are there any tweaking commands related to this directory settings, also how can I cleanup/truncate this directory without impacting the overall database.
Are there any tweaking commands related to this directory settings, also how can I cleanup/truncate this directory without impacting the overall database.
Looking forward to get some insight here.
