citusdata / citusdata/citus_docs

Explicit filter by dist column for efficiency

Open
#750 0 comments 0 reactions 0 assignees View on GitHub
SE
Dominant language
CSS
Stars
58
Forks
60
PR merge metrics
No merged PRs in 30d

Description

## Communication goals (e.g. detailed howto vs orientation)

When filtering by a column on which the distribution column functionally depends, the query will go faster if you also include the distribution column in the filter. This won't change the results, it merely allows Citus to prune shards efficiently.

### Good locations for content in docs structure

Section in http://docs.citusdata.com/en/v7.5/performance/performance_tuning.html about writing fast select statements.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.