Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208282=pgsql-general-arkari@postgresql.org>)
 id 1XUFdW-0001dP-Gw
 for pgsql-general@arkaria.postgresql.org; Wed, 17 Sep 2014 13:51:10 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M208282=pgsql-general-arkari@postgresql.org>)
 id 1XUFdV-0007tz-FO
 for pgsql-general@arkaria.postgresql.org; Wed, 17 Sep 2014 13:51:09 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <devdas.kumkar@gmail.com>)
 id 1XUFdR-0007lg-3M; Wed, 17 Sep 2014 13:51:05 +0000
Received: from mail-la0-x22a.google.com ([2a00:1450:4010:c03::22a])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <devdas.kumkar@gmail.com>)
 id 1XUFdN-0001A5-6w; Wed, 17 Sep 2014 13:51:03 +0000
Received: by mail-la0-f42.google.com with SMTP id hz20so1900143lab.1
 for <multiple recipients>; Wed, 17 Sep 2014 06:50:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=qqrgvCKNxzn7NE0ZijZaxDKrK6c+yRlOxz48EdOUDNk=;
 b=TeAhzk2Or5as4oIE/TUKlGHK0Krtw8RIinXyj8XETloLn1W0pWP7yTXWZWYYoDo00I
 22FlzRmmGndrxrYkf3uxirKM7yFXmNq8ziXRVTH0Tg46tfkBr/a/t4RcccHHmANJP616
 E5nGDddOuaBI5h7jy1oVDdW99jLOVuLH7O+rlnhgYEz6vIjNrtoeCuCsWJuEEHczIsCc
 yP4wP1Ze0ettQ3vD55YE8ED4WW8OJyyRkSJUvJlkvrzUnJH8FyF3rjFlg+w3Ap8PyDqv
 9sL1245TUfjRDV0MccRnwo0NzNp9ajEueNXXbLeLK+sO3otaZDjSn5QSByw2EIRTeGXS
 ZHsw==
MIME-Version: 1.0
X-Received: by 10.152.37.169 with SMTP id z9mr25385097laj.66.1410961858493;
 Wed, 17 Sep 2014 06:50:58 -0700 (PDT)
Received: by 10.112.51.6 with HTTP; Wed, 17 Sep 2014 06:50:58 -0700 (PDT)
In-Reply-To: <54198AEB.2070508@aklaver.com>
References: 
 <CALSLE1P4knmyFa5BzdeYo7fVnjw-1-TwW9dXTEW-9nJjK4fQMg@mail.gmail.com>
 <54198AEB.2070508@aklaver.com>
Date: Wed, 17 Sep 2014 19:20:58 +0530
Message-ID: 
 <CALSLE1Pywi4SAyvOVHn+FfxTHMF88t4esgPXxwS9etWMzeE0Rg@mail.gmail.com>
Subject: Re: [SQL] pg_multixact issues
From: Dev Kumkar <devdas.kumkar@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
 pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=089e014940525e03eb0503432833
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

--089e014940525e03eb0503432833
Content-Type: text/plain; charset=UTF-8

On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

>
> http://www.postgresql.org/docs/9.3/static/routine-
> vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND
>
> Might also want to take a look at pg_stat_activity to see what queries
> maybe hanging up:
>
>
> http://www.postgresql.org/docs/9.3/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW


Thanks, yes have been looking into pg_stat_activity table and somehow the
standard queries are hanging.
Not sure if this is because the database response has become very slow.

Regards...

--089e014940525e03eb0503432833
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On W=
ed, Sep 17, 2014 at 6:51 PM, Adrian Klaver <span dir=3D"ltr">&lt;<a href=3D=
"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.=
com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div class=3D""><div class=3D"h5"><br>
</div></div><a href=3D"http://www.postgresql.org/docs/9.3/static/routine-va=
cuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND" target=3D"_blank">http://www.=
postgresql.org/<u></u>docs/9.3/static/routine-<u></u>vacuuming.html#VACUUM-=
FOR-<u></u>MULTIXACT-WRAPAROUND</a><br>
<br>
Might also want to take a look at pg_stat_activity to see what queries mayb=
e hanging up:<br>
<br>
<a href=3D"http://www.postgresql.org/docs/9.3/static/monitoring-stats.html#=
PG-STAT-ACTIVITY-VIEW" target=3D"_blank">http://www.postgresql.org/docs/9.3=
/static/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW</a></blockquote><div><b=
r></div><div>Thanks, yes have been looking into pg_stat_activity table and =
somehow the standard queries are hanging.<br></div><div>Not sure if this is=
 because the database response has become very slow.<br><br></div><div>Rega=
rds...<br></div></div></div></div>

--089e014940525e03eb0503432833--