Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add option to create indexes, and don't do it while creating schema #1

Open
jeroarenas opened this issue Nov 8, 2021 · 1 comment
Assignees
Labels
enhancement New feature or request

Comments

@jeroarenas
Copy link
Collaborator

If indexes are created from the beginning, data loading on the postgres db will be very slow. It is better to load data first, and then create indexes once the data is ready. Two choices are given:

  • Preferred: Create indexes on each table after ingesting all data relevant to that table
  • Other: Create a new option in the menu to create indexes at the very end
@jeroarenas jeroarenas added the enhancement New feature or request label Nov 8, 2021
@jeroarenas
Copy link
Collaborator Author

For the time being, I have modified create_schema to remove index creation. It should be placed somewhere else, after population of the tables.

I have also removed from that file the creation of the LEMAS table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants