Jira (PDB-763) Handle creation of pg_trgm indexes for structure facts
Title: Message Title Kenneth Barber assigned an issue to Kenneth Barber PuppetDB / PDB-763 Handle creation of pg_trgm indexes for structure facts Change By: Kenneth Barber Assignee: KennethBarber Add Comment 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.
Jira (PDB-763) Handle creation of pg_trgm indexes for structure facts
Title: Message Title Kenneth Barber updated an issue PuppetDB / PDB-763 Handle creation of pg_trgm indexes for structure facts Change By: Kenneth Barber Sprint: 20140730to20140813 Add Comment 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.
Jira (PDB-763) Handle creation of pg_trgm indexes for structure facts
Title: Message Title Kenneth Barber created an issue PuppetDB / PDB-763 Handle creation of pg_trgm indexes for structure facts Issue Type: Task Assignee: Unassigned Created: 14/Jul/14 8:10 AM Fix Versions: 2.2.0 Priority: Normal Reporter: Kenneth Barber This task has been split out due to the nature of installing extensions and what not. The goal here is to have our software notice if the pg_trgm module isn't installed, and warn the user. This is because the puppetdb db user won't often have superuser permissions to do this itself. If the pg_trgm index exists, we should install the correct indexes on fact_values.value_string and fact_paths.path to get the performance we want. We might need to do this as a separate task from migration, but after migration specifically. I believe the trgm indexes full benefits are surfaced in 9.3, so we might want to also cowardly refuse the indexes unless they are running 9.3 or above. I'm more inclined to want to avoid the index type in 9.2 and below, since I'm not sure its that fast there for regexp searching. While we are at it, we could deprecate pre 9.3 databases, we already have the code for this so the change is pretty minor.