pg_multixact issues
| От | Dev Kumkar |
|---|---|
| Тема | pg_multixact issues |
| Дата | |
| Msg-id | CALSLE1P4knmyFa5BzdeYo7fVnjw-1-TwW9dXTEW-9nJjK4fQMg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: [SQL] pg_multixact issues
Re: pg_multixact issues |
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: