Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] pg_multixact issues - Mailing list pgsql-general

From Dev Kumkar
Subject Re: [SQL] pg_multixact issues
Date
Msg-id CALSLE1P-1B+u5sO-mEjR0yc3SSD_fvGh0ZZ=ZgnGVspaCCjmfA@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] pg_multixact issues  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view
On Tue, Sep 30, 2014 at 8:50 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Did you try decreasing the autovacuum_multixact_freeze_min_age and
autovacuum_multixact_freeze_table_age parameters?
As per the docs this set anywhere from zero to 1 billion for vacuum_multixact_freeze_min_age
And zero to 2 billion for vacuum_multixact_freeze_table_age.

Modified this to have value 10 and 15 respectively. Not sure if that's correct way of setting these parameters?

What exact server version are you running?
 Am using PostgreSQL 9.3.4 (linux-64-bit)

Regards...

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: table versioning approach (not auditing)
Next
From: Roger Pack
Date:
Subject: ability to return number of rows inserted into child partition tables request