citusdata / citusdata/cstore_fdw
Hash-based indexes
Open
enhancement
- Dominant language
- C
- Stars
- 1.8k
- Forks
- 169
- PR merge metrics
- No merged PRs in 30d
Description
I'm not familiar enough with FDWs to know for sure if this could work with the query planner, but I think it would be beneficial to use hash based indexes. In this sense, you could get away with not storing the indexed columns as columns, but store the hash in the table data similar to how you store skiplists. I think this would be extremely beneficial for data size and its implicit performance. I believe this is the strategy that kdb+ uses for its database (which is pretty ubiquitous in HFT).
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.