Jira (PDB-2424) DELETE FROM edges is extremely slow

[Daniele Sluijters (JIRA)]

Title: Message Title

Daniele Sluijters created an issue   PuppetDB / PDB-2424 DELETE FROM edges is extremely slow Issue Type: Bug Assignee: Unassigned Created: 2016/02/11 8:00 AM Priority: Normal Reporter: Daniele Sluijters We were seeing a lot of DELETE FROM edges queries taking 4-6s or more. We added some indices on edges which seems to have solved it: "edges_certname_idx" btree (certname) "edges_source_hex_idx" btree (encode(source, 'hex'::text)) "edges_target_hex_idx" btree (encode(target, 'hex'::text)) "edges_type_idx" btree (type) Add Comment   This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.