Postgres Pro
Downloads
Home   >   mailing lists

Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%) - Mailing list pgsql-general

From Adrian Klaver
Subject Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%)
Date
Msg-id 33f4671a-1d3e-e7ef-3466-4433ea25c7b2@aklaver.com
Whole thread Raw
In response to Re: POSTGRES_FSM_RELATIONS CRITICAL: DB control fsm relations used:79569 of 80000 (99%)  (Julie Nishimura <juliezain@hotmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jeremy Finzel
Date:
Subject: Re: Questions about btree_gin vs btree_gist for low cardinality columns
Next
From: Yonatan Misgan
Date:
Subject: Localization