| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Yogesh Sharma <yogeshraj95(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Size of pg_multixact/members increases 11355 |
| Date: | 2017-12-13 15:08:28 |
| Message-ID: | 19c568ed-7dbb-f616-5b38-7f6175b3d276@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/13/2017 01:42 PM, Yogesh Sharma wrote:
> Dear Thomas ,
>
> Thanks for sharing information.
>
> Is it possible to remove mentioned folder files in some time intervals
> by some DB command?
> Currently i can not upgrade to 3.6.20.
> So please share if any solution is available.
>
There are no explicit commands to remove them. When the database decides
those files are not needed, it'll remove them automatically.
It's strongly discouraged to mess with those files directly, as it may
easily lead to data loss or data corruption, particularly when it's
unclear why the directory got so large.
You could try setting autovacuum_multixact_freeze_max_age=0 and
vacuuming the database, but it's hard to say if that will help.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-12-13 15:20:31 | Re: Dependency tree to tie type/function deps to a table |
| Previous Message | Jeremy Finzel | 2017-12-13 15:07:16 | Dependency tree to tie type/function deps to a table |