[MADLIB-1369] Investigate index creation for PG in APSP and SSSP

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: v3.0.0
• Component/s: Module: Graph
• Assignee: Unassigned
• Reporter: Nandish Jayaram
• Created: 02/Jul/19 21:36
• Updated: 12/Feb/20 19:33

Description

Follow on story from https://issues.apache.org/jira/browse/MADLIB-1368
We create index for one of the tables created in SSSP and APSP for Postgres. This index creation may or may not be required, and this story must investigate the same. Indexes could also potentially hurt the performance because we do multiple updates on it.

Acceptance:
Find if index is needed (perf runs?)
If not needed, remove it.