Jira (PDB-887) Reduce fact_value storage

[Kenneth Barber (JIRA)]

Title: Message Title

Kenneth Barber commented on an issue   Re: Reduce fact_value storage Thanks heaps Stefan Goethals. I actually amended those queries like 10 times before settling on the ones above - sorry about that, can you take another look and run the new ones instead? Cheers . Add Comment   PuppetDB / PDB-887 Reduce fact_value storage The fact_values table is quite large under heavily loaded circumstances, we should work to reduce that: * storage of integers, booleans and doubles have little value in being de-duplicated, we could move these to facts instead, and just have the updated differentially only. Only strings and JSON blobs would then be de-duplicated basically. * fact_valu... This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.