From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: pg_multixact issues |
Date: | 2014-09-18 09:11:07 |
Message-ID: | CALSLE1NT9c9eYs95Q3=7C5dWkzrrULQTy6bcSkFsP1OKA+AXHg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
On Thu, Sep 18, 2014 at 2:41 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
>
> Aaah, hit enter too soon. Also see the other changes under Changes that
> apply to multixact in 9.3.5
Thanks for sharing same. Found this one interesting "Truncate pg_multixact
during checkpoints, not during VACUUM (Álvaro Herrera)" and also other
changes. But am not sure are you suggesting to move to 9.3.5 ?
Actually looking for some guidelines on truncating pg_multixact at this
situation.
- Do I need to run vaccum manually here and then the pg_multixact can be
truncated?
- Actually looking out for some hints wherein can know the current
pg_multixact/members which are active and which one are stale which can be
truncated? Is there any query to find this information?
pg_class.relminmxid can be referred but should I change the value of
autovacuum_multixact_freeze_max_age which defaults to 400 million
multixacts, setting this value to lower limits would help in cleaning up
pg_multixact?
Regards...
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-09-18 10:33:38 | Re: [SQL] pg_multixact issues |
Previous Message | Misa Simic | 2014-09-18 07:55:10 | Re: Why isn't Java support part of Postgresql core? |
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2014-09-18 09:30:38 | Re: New developer TODO suggestions |
Previous Message | Andres Freund | 2014-09-18 08:31:48 | Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations() |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-09-18 10:33:38 | Re: [SQL] pg_multixact issues |
Previous Message | Adrian Klaver | 2014-09-17 21:11:36 | Re: [SQL] pg_multixact issues |