I want to insert the whole dbSNP VCF files (both grch37 and 38) into database. Postgres, or MySQL.
Has anyone done this?
How do you deal with the size of the table?
All in one table or partition it?
If partitioned, how do you query?
Thank you in advance!