On 09/17/2014 05:16 AM, Dev Kumkar wrote:
Hello,
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.
http://www.postgresql.org/docs/9.3/static/routine-vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND
Might also want to take a look at pg_stat_activity to see what queries
maybe hanging up:
http://www.postgresql.org/docs/9.3/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
Looking forward to get some insight here.
Regards...
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
