Partition locus/variant/annotation tables by contig
Open
optimisation
- Dominant language
- Python
- Stars
- 30
- Forks
- 3
- Avg merge
- 9h 28m
- Merged PRs (30d)
- 42
Description
Working in branch **partition_by_contig**
----------
Then add contig to every query, this would presumably speed up eg gene and variant queries (as we'd have much smaller table to scan)
Remember to look into the new Postgres partitions, if AWS supports it.
Variant - partition by alt = "=" (reference) may be useful
Otherwise you have to partition off a field in that table (ie no relations) so you can't eg partition variant by contig, unless you add contig to the table (duplicating 1/3 of Locus table)
Do at the same time as #12
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.