On 2019-May-28, Julie Nishimura wrote: > Adrian, I am trying to avoid to do any tweaking to this legacy system that > nobody knows well (we inherited it recently). > Do you think it might help if we possibly drop old tables (I assume their > indices will be removed too), so the overall number of objects will go down? > Thanks a lot
Having insufficient max_fsm_relations causes severe problems, so don't if you can avoid it. I would certainly recommend increasing it. Note that increasing max_fsm_relations requires that you have a large enough shared memory allowance in the operating system; if you're too close to the limit and try to restart with the increased setting, the service may fail to start. However, unless you're on something weird that requires recompiling the kernel to update that limit, it should be fairly simple to update it. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
