Message-ID: <541C3339.3080708@2ndquadrant.com>
Date: Fri, 19 Sep 2014 10:44:25 -0300
From: Emanuel Calvo <emanuel.calvo@2ndquadrant.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: pg_multixact issues
References: 
 <CALSLE1P4knmyFa5BzdeYo7fVnjw-1-TwW9dXTEW-9nJjK4fQMg@mail.gmail.com>
	<20140917132308.GC25775@awork2.anarazel.de>
 <CALSLE1NT4_R_RdK7d6WnoGxAgZnqW2iNowraGDbMYX-Jk6Ccvw@mail.gmail.com>
In-Reply-To: 
 <CALSLE1NT4_R_RdK7d6WnoGxAgZnqW2iNowraGDbMYX-Jk6Ccvw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------070904030404070702040400"
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

This is a multi-part message in MIME format.
--------------070904030404070702040400
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit


El 17/09/14 10:51, Dev Kumkar escribió:
> On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund <andres@2ndquadrant.com
> <mailto:andres@2ndquadrant.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


--------------070904030404070702040400
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <div class="moz-cite-prefix">El 17/09/14 10:51, Dev Kumkar escribió:<br>
    </div>
    <blockquote
cite="mid:CALSLE1NT4_R_RdK7d6WnoGxAgZnqW2iNowraGDbMYX-Jk6Ccvw@mail.gmail.com"
      type="cite">
      <meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_extra">
          <div class="gmail_quote">On Wed, Sep 17, 2014 at 6:53 PM,
            Andres Freund <span dir="ltr">&lt;<a moz-do-not-send="true"
                href="mailto:andres@2ndquadrant.com" target="_blank">andres@2ndquadrant.com</a>&gt;</span>
            wrote:<br>
            <blockquote class="gmail_quote"><span class="">On 2014-09-17
                17:46:05 +0530, Dev Kumkar wrote:<br>
                &gt; On one my machine the pg_multixact directory size
                has grown up to 5 GB and<br>
                &gt; am not sure how to clean up this directory.<br>
                <br>
              </span>Which version of postgres are you using?<br>
              <br>
              Greetings,<br>
              <br>
              Andres Freund<br>
            </blockquote>
            <div><br>
            </div>
            <div>Postgres 9.3.4 (linux-64-bit)<br>
              <br>
            </div>
            <div>Regards... <br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    Could it be related to some fixes on 9.3.5?:<br>
    <br>
    - Fix wraparound handling for pg_multixact/members (Álvaro Herrera)<br>
    - Truncate pg_multixact during checkpoints, not during VACUUM
    (Álvaro Herrera)<br>
    <br>
    <pre class="moz-signature" cols="72">-- 
--
Emanuel Calvo                 <a class="moz-txt-link-freetext" href="http://www.2ndQuadrant.com/">http://www.2ndQuadrant.com/</a>
PostgreSQL Development, 24x7 Support, Training &amp; Services</pre>
  </body>
</html>

--------------070904030404070702040400--