Indices missing?

[mwaterman29]

Hi,

Forgive me if this is documented somewhere - but have the indices changed? When downloading the latest .dmp file, I'm seeing a small fraction of the indices. Using pg_restore -l "$DUMP_FILE" > dump_contents.list, I see the following:

...constraints...
4267; 1259 54735520 INDEX ctgov index_mesh_headings_on_qualifier ctti
4268; 1259 65468509 INDEX ctgov index_mesh_headings_on_qualifier_heading_subcategory ctti
4271; 1259 54735521 INDEX ctgov index_mesh_terms_on_description ctti
4272; 1259 54735522 INDEX ctgov index_mesh_terms_on_downcase_mesh_term ctti
4273; 1259 54735523 INDEX ctgov index_mesh_terms_on_mesh_term ctti
4274; 1259 54735524 INDEX ctgov index_mesh_terms_on_qualifier ctti
4250; 1259 54735551 INDEX ctgov index_studies_on_nct_id ctti
4311; 1259 54735564 INDEX ctgov index_study_searches_on_query_and_grouping ctti
4378; 2620 54735565 TRIGGER ctgov categories category_insert_trigger ctti
...continues on to FK constraints...

However, in your code (after just a brief search) - I see that it seems like there should be a lot more indices:

aact/db/admin_structure.sql

Line 7959 in 46fc0a9

CREATE INDEX index_baseline_measurements_on_dispersion_type ON ctgov.baseline_measurements USING btree (dispersion_type);

Additionally, from previous restores, old DB copies had many, many more indices. If this is intentional, no worries, but it seems like there might be an issue regarding index creation statements when creating the actual dmp file.