We are handling around 6k nodes with around 30 custom facts. The database is growing bigger than expected, whereas the table m_hostfacts seems to be the one showing something as huge as 2664429 relnames. Not sure if that is related, but the process to add new nodes takes several minutes. Server has 16 Gb of ram and only 150-250 available.
Is that table really need to be that big? Is it normal for new nodes to take minutes to be showed on foreman gui?
Foreman and Proxy versions:
Other relevant data:
We got a domain change in the nodes, all of our nodes need to register again, but postgres database seems to have troubles. Foreman GUI and database are on different servers.