Jira (PDB-1813) Run the state-overview queries as a single query.
Title: Message Title Ryan Senior updated an issue PuppetDB / PDB-1813 Run the state-overview queries as a single query. Change By: Ryan Senior Fix Version/s: PDB 3.1.0 Fix Version/s: PDB 3.2.0 Add Comment This message was sent by Atlassian JIRA (v6.4.5#64020-sha1:78acd6c) -- 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-1813) Run the state-overview queries as a single query.
Title: Message Title Scott Walker commented on PDB-1813 Re: Run the state-overview queries as a single query. State Overview isn't filter-aware (and shouldn't ever be imo as that's a very CM-specific and fluid concept - see PDB-1849). We're calculating these aggregates ourselves in most cases now. I'd go as far as saying we can deprecate the remove this endpoint. It would be more valuable from our POV to fix PDB-1820 I think. Add Comment This message was sent by Atlassian JIRA (v6.4.5#64020-sha1:78acd6c) -- 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-1813) Run the state-overview queries as a single query.
Title: Message Title Andrew Roetker commented on PDB-1813 Re: Run the state-overview queries as a single query. This is not a requirement for Scott Walker but we should probably do this anyways (running state-overview in a single query) to eliminate the race condition across multiple queries, or at least run all the queries in the same database transaction. Add Comment This message was sent by Atlassian JIRA (v6.4.5#64020-sha1:78acd6c) -- 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-1813) Run the state-overview queries as a single query.
Title: Message Title Andrew Roetker updated an issue PuppetDB / PDB-1813 Run the state-overview queries as a single query. Change By: Andrew Roetker Sprint: PuppetDB 2015-08-12 Add Comment This message was sent by Atlassian JIRA (v6.4.5#64020-sha1:78acd6c) -- 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-1813) Run the state-overview queries as a single query.
Title: Message Title Andrew Roetker created an issue PuppetDB / PDB-1813 Run the state-overview queries as a single query. Issue Type: Improvement Affects Versions: PDB 3.0.0 Assignee: Unassigned Created: 2015/07/17 2:30 PM Fix Versions: PDB 3.1.0 Priority: Normal Reporter: Andrew Roetker Scott Walker may be able to provide more context here, but it has been brought up that having the state-overview endpoint use three queries to provide its view is not fast enough for the number of nodes state-overview has to support and will only get worse in Ankeny. Unchanged resources work will require us to have PE only query-recs, as there will be PE only tables. That means we will need the ability to pass query-recs to the PuppetDB in-process `query-fn`, in addition to the `:keyword`s we pass today, e.g. we would be able to pass `reports/query->sql` or `:reports` to query the reports endpoint. We could use the same idea here as well and have a state-overview query-rec that looks like