Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%)

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%)
Дата
Msg-id 33f4671a-1d3e-e7ef-3466-4433ea25c7b2@aklaver.com
обсуждение исходный текст
Ответ на Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%)  (Julie Nishimura <juliezain@hotmail.com>)
Список pgsql-general
On 5/29/19 9:41 AM, Julie Nishimura wrote:
> Just for those who might be interested... We increased the settings for 
> max_fsm_relations, max_fsm_pages and restarted the service. It came up 
> with no problem. And it looks like after the restart of the psql service 
> the utilization of fsm_relations was reset to 0.
> POSTGRES_FSM_RELATIONS OK: DB control (host:10.24.33.13) fsm relations 
> used: 84 of 160000 (0%)
> 
> I was expecting the used fsm_relations to continue its count from 80k, 
> but instead it looks like it reset, which gives us even more room to grow.
> 

FSM is tied to VACUUM, so as VACUUM is run over tables the count will 
increase.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeremy Finzel
Дата:
Сообщение: Re: Questions about btree_gin vs btree_gist for low cardinality columns
Следующее
От: Yonatan Misgan
Дата:
Сообщение: Localization