Re: pg_multixact issues

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: pg_multixact issues
Дата
Msg-id CALSLE1Pywi4SAyvOVHn+FfxTHMF88t4esgPXxwS9etWMzeE0Rg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_multixact issues  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: pg_multixact issues  (Dev Kumkar <devdas.kumkar@gmail.com>)
Re: pg_multixact issues  (Dev Kumkar <devdas.kumkar@gmail.com>)
Список pgsql-sql
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [GENERAL] pg_multixact issues
Следующее
От: Dev Kumkar
Дата:
Сообщение: Re: [GENERAL] pg_multixact issues