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.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to