Re: [SQL] pg_multixact issues

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: [SQL] pg_multixact issues
Дата
Msg-id CALSLE1P-1B+u5sO-mEjR0yc3SSD_fvGh0ZZ=ZgnGVspaCCjmfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] pg_multixact issues  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: table versioning approach (not auditing)
Следующее
От: Roger Pack
Дата:
Сообщение: ability to return number of rows inserted into child partition tables request