Description of problem:

Satellite currently pulls in all facts reported by clients. This can lead to an extremely large (>50K) fact_names table, which can make fact import slow down. Eventually, this will lead to transaction errors logged to production.log during fact import.

For example:

[app] [E] Fact dmi::system::uuid could not be imported because of PG::Error: ERROR: duplicate key value violates unique constraint "index_fact_values_on_fact_name_id_and_host_id"

Version-Release number of selected component (if applicable): 6.2.14/6.3.0

How reproducible: not every time

Steps to Reproduce:
1. pull in a customer DB with a lot of fact_names
2. perform simultaneous registrations and checkins (perhaps 5 concurrent, maybe more)
3. watch for errors in production.log

Actual results: postgres errors, failed registrations

Expected results: no errors

Additional info: There are a couple of similar errors you may get. I usually see "[app] [E] Fact dmi::system::uuid could not be imported because of PG::Error: ERROR: duplicate key value violates unique constraint "index_fact_values_on_fact_name_id_and_host_id"".