Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Kurt Wall updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Kurt Wall Althoughourcurrenttablestructureismoreefficientfromaspaceperspective,it'smorecostlytoquery.Weshouldcreateamigrationthatdropsthefactpathidfromthefact_valuestableandinsteadhavethefactstablepointatboththefactvalueandthefactpathalongwiththefactset.Aquickfirstpassatthismigrationwillallowthefactdiffinglogictobeupdatedinparallel.Careneedstobetakenthatwedothismigrationefficientlyandquicklyasitwillbeaddinganew(populated,non-null)columnonatablethatispotentiallyverylarge. h3.QARiskAssessment|Probability|Low(re-arranginginternals)||Impact|Medium(limited,notcatastrophic)||RiskLevel|Low||TestLevel|Unit| Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Kurt Wall updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Kurt Wall QA Contact: KurtWall Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Kurt Wall updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Kurt Wall QA Status: Reviewed Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Rob Browning assigned an issue to Rob Browning PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Rob Browning Assignee: RobBrowning Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Steve Barlow Story Points: 2 1 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Steve Barlow Sprint: PuppetDB2015-02-25,PuppetDB2015-03-11,PuppetDB2015-03-25 ,PuppetDB2015-04-08 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Rob Browning updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Rob Browning Fix Version/s: PDB2.3.0 Fix Version/s: PDB2.3.x Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Steve Barlow Sprint: PuppetDB2015-02-25,PuppetDB2015-03-11 ,PuppetDB2015-03-25 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Wyatt Alt assigned an issue to Rob Browning PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Wyatt Alt Assignee: RobBrowning Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Steve Barlow Sprint: PuppetDB2015-02-25 ,PuppetDB2015-03-11 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Rob Browning commented on PDB-1224 Re: Move fact path reference from the fact_values table to the facts table Tested several approaches and settled on creating a migration facts table explicitly from scratch for now. We just drop the dead columns from the other tables since that should be quite cheap with postgresql. Current version of the code should be here: https://github.com/rbrw/puppetdb/compare/ticket/master/pdb-1224-lift-fact-paths-into-facts Note that this code will break puppetdb until PDB-1225 is ready. Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Kenneth Barber updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Kenneth Barber Fix Version/s: PDB2.3.0 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Rob Browning assigned an issue to Rob Browning PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Rob Browning Assignee: RobBrowning Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Ryan Senior created an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Issue Type: Bug Assignee: Unassigned Created: 2015/02/10 12:38 PM Priority: Normal Reporter: Ryan Senior Although our current table structure is more efficient from a space perspective, it's more costly to query. We should create a migration that drops the fact path id from the fact_values table and instead have the facts table point at both the fact value and the fact path along with the factset. A quick first pass at this migration will allow the fact diffing logic to be updated in parallel. Care needs to be taken that we do this migration efficiently and quickly as it will be adding a new (populated, non-null) column on a table that is potentially very large. Add Comment
Jira (PDB-1224) Move fact path reference from the fact_values table to the facts table
Title: Message Title Ryan Senior updated an issue PuppetDB / PDB-1224 Move fact path reference from the fact_values table to the facts table Change By: Ryan Senior Sprint: PuppetDB2015-02-25 Add Comment This message was sent by Atlassian JIRA (v6.3.10#6340-sha1:7ea293a) -- 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.
