Re: pg_multixact issues

From: Emanuel Calvo <emanuel(dot)calvo(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_multixact issues
Date: 2014-09-19 13:44:25
Message-ID: 541C3339.3080708@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql


El 17/09/14 10:51, Dev Kumkar escribió:
> On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund <andres(at)2ndquadrant(dot)com
> <mailto:andres(at)2ndquadrant(dot)com>> wrote:
>
> On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote:
> > 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.
>
> Which version of postgres are you using?
>
> Greetings,
>
> Andres Freund
>
>
> Postgres 9.3.4 (linux-64-bit)
>
> Regards...
Could it be related to some fixes on 9.3.5?:

- Fix wraparound handling for pg_multixact/members (Álvaro Herrera)
- Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro
Herrera)

--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-09-19 14:09:05 Re: pg_multixact issues
Previous Message Craig Ringer 2014-09-19 12:50:54 Re: cloning database

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-09-19 13:58:01 Re: GCC memory barriers are missing "cc" clobbers
Previous Message Heikki Linnakangas 2014-09-19 12:40:14 Re: jsonb format is pessimal for toast compression

Browse pgsql-sql by date

  From Date Subject
Next Message Dev Kumkar 2014-09-19 14:09:05 Re: pg_multixact issues
Previous Message Dev Kumkar 2014-09-19 07:53:42 Re: [GENERAL] pg_multixact issues