Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_multixact issues - Mailing list pgsql-sql

From Dev Kumkar
Subject Re: pg_multixact issues
Date
Msg-id CALSLE1Pywi4SAyvOVHn+FfxTHMF88t4esgPXxwS9etWMzeE0Rg@mail.gmail.com
Whole thread Raw
In response to Re: pg_multixact issues  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_multixact issues  (Dev Kumkar <devdas.kumkar@gmail.com>)
Re: pg_multixact issues  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-sql
Tree view
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...

pgsql-sql by date:

Previous
From: Andres Freund
Date:
Subject: Re: [GENERAL] pg_multixact issues
Next
From: Dev Kumkar
Date:
Subject: Re: [GENERAL] pg_multixact issues