cockroachdb / cockroachdb/django-cockroachdb

Best practices for index USING HASH (...or USING HASH WITH BUCKET_COUNT) ?

Open
#264 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
174
Forks
31
PR merge metrics
No merged PRs in 30d

Description

This is about CRDB's hash sharded index feature for sequential indexes / primary keys: https://www.cockroachlabs.com/blog/hash-sharded-indexes-unlock-linear-scaling-for-sequential-workloads/

Is there any way to use this feature?

I've tried passing various arguments to `_create_index_sql()`:

`condition=`
`include=`
`db_tablespace=`
`expressions=`

With no success.

It may require an extra entry in https://github.com/cockroachdb/django-cockroachdb/blob/master/django_cockroachdb/schema.py to handle this use case?

Any comments, thoughts, appreciated.

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.