From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] pg_multixact issues |
Date: | 2014-09-17 21:11:36 |
Message-ID: | 5419F908.2080303@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
On 09/17/2014 01:36 PM, Dev Kumkar wrote:
> On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com
> <mailto:devdas(dot)kumkar(at)gmail(dot)com>> wrote:
>
> On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
>
> http://www.postgresql.org/__docs/9.3/static/routine-__vacuuming.html#VACUUM-FOR-__MULTIXACT-WRAPAROUND
> <http://www.postgresql.org/docs/9.3/static/routine-vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND>
>
>
> Looked into these details. Can there be an example explained that will
> really help to understand this in practice?
>
> Also one additional information here, the database was restarted various
> times. But still the pg_multixact directory size is increasing.
> Actually there were multiple updates happening in different processes
> which lead to the locking issues and landed up into this situation.
>
> How can I recover the system at this stage and also clean up
> pg_multixact gracefully?
Aaah, hit enter too soon. Also see the other changes under Changes that
apply to multixact in 9.3.5
>
> Regards...
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | cowwoc | 2014-09-17 21:27:38 | Re: Why isn't Java support part of Postgresql core? |
Previous Message | Adrian Klaver | 2014-09-17 21:08:59 | Re: pg_multixact issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Marti Raudsepp | 2014-09-17 22:02:39 | Re: Final Patch for GROUPING SETS |
Previous Message | Adrian Klaver | 2014-09-17 21:08:59 | Re: pg_multixact issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Dev Kumkar | 2014-09-18 09:11:07 | Re: pg_multixact issues |
Previous Message | Adrian Klaver | 2014-09-17 21:08:59 | Re: pg_multixact issues |