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@xxxxxxxxxxx
