SACGF / SACGF/variantgrid

Partition locus/variant/annotation tables by contig

Open
#300 9 comments 0 reactions 1 assignee Claimed by @davmlaw View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.