Create indexes in PSQL database

[hannahkates]

@hannahkates commented on Tue Sep 17 2019

Tables, columns to index:

• contact
  • contactid
  • emailaddress1
• dcp_project
  • dcp_projectid
• dcp_projectmilestone
  • dcp_project
  • dcp_milestone
• dcp_projectaction
  • dcp_project
  • dcp_action
  • dcp_ulurpnumber
• dcp_communityboarddisposition
  • dcp_communityboarddispositionid
  • dcp_project
  • dcp_projectaction
  • dcp_recommendationsubmittedby
• dcp_projectlupteam
  • dcp_lupteammemberrole
  • dcp_lupteammember

CREATE INDEX contactid_idx
  ON contact (contactid);
CREATE INDEX emailaddress1_idx
  ON contact (emailaddress1);

CREATE INDEX dcp_projectid_idx
  ON dcp_project (dcp_projectid);

CREATE INDEX dcp_project_milestone_idx
  ON dcp_projectmilestone (dcp_project);
CREATE INDEX dcp_milestone_idx
  ON dcp_projectmilestone (dcp_milestone);

CREATE INDEX dcp_project_action_idx
  ON dcp_projectaction (dcp_project);
CREATE INDEX dcp_action_idx
  ON dcp_projectaction (dcp_action);
CREATE INDEX dcp_ulurpnumber_idx
  ON dcp_projectaction (dcp_ulurpnumber);

CREATE INDEX dcp_communityboarddispositionid_idx
  ON dcp_communityboarddisposition (dcp_communityboarddispositionid);
CREATE INDEX dcp_project_disposition_idx
  ON dcp_communityboarddisposition (dcp_project);
CREATE INDEX dcp_projectaction_idx
  ON dcp_communityboarddisposition (dcp_projectaction);
CREATE INDEX dcp_recommendationsubmittedby_idx
  ON dcp_communityboarddisposition (dcp_recommendationsubmittedby);

CREATE INDEX dcp_lupteammemberrole_idx
  ON dcp_projectlupteam (dcp_lupteammemberrole);
CREATE INDEX dcp_lupteammember_idx
  ON dcp_projectlupteam (dcp_lupteammember);

[allthesignals]

• Remaining task here is technical debt... need to turn this into a migration or just add it to a "scripts" folder.

[hannahkates]

Replaced by https://github.com/NYCPlanning/labs-zap-search/issues/849