Add indexes on searched DB columns
Add the missing indexes declaration on DB model using SQLAlchemy notation:
- CREATE INDEX obs_target_name ON obsportal.observation(target_name);
- CREATE INDEX obs_spatial ON obsportal.observation USING GIST(spoint(radians(target_ra),radians(target_dec)));
See:
Edited by Philippe Bollard