Jira (PDB-887) Reduce fact_value storage

JIRA Fri, 26 Sep 2014 07:59:49 -0700

Title: Message Title

Erik Dalén commented on an issue

puppetdb=# select c, count(c) from (select count(id) as c from fact_values where value_type_id = 0 group by value_hash order by c) as counts group by c;

  c  |  count

-----+---------

   1 | 3696620

   2 |   64766

   3 |    5756

   4 |      95

   5 |      22

   6 |     148

   7 |       9

   8 |      10

   9 |       4

  10 |       7

  11 |       3

  12 |       4

  13 |       5

  14 |       1

  16 |      10

  19 |       1

  20 |       2

  21 |       1

  24 |       1

  32 |       2

  48 |       3

  64 |       2

  87 |       2

  89 |       4

  91 |       1

 101 |       1

 348 |       1

(27 rows)

puppetdb=# select c, count(c) from (select count(id) as c from fact_values where value_type_id = 5 group by value_hash order by c) as counts group by c;

 c |  count

---+---------

 1 | 1256286

(1 row)

Add Comment

PuppetDB /

PDB-887

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

--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.

Jira (PDB-887) Reduce fact_value storage

Reply via email to