citusdata / citusdata/citus_docs

Improve query performance tuning section

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

Description

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

The section is fairly dense and contains historical cruft.

* "Table Distribution and Shards" is more like "Picking the best column for distribution"
* References older postgres versions, like the pg 9.0 performance book
* Add links to postgres docs for settings (e.g. shared_buffers)
* The postgresql tuning section contents should be separated better into subtopics
* EXPLAIN
* config params
* etc
* Add bulleted summaries to sections. The denser paragraphs will exist to support and explain the claims of the summaries.
* Add a diagram of push-pull execution to the CTE overhead section

### Good locations for content in docs structure

http://docs.citusdata.com/en/v7.5/performance/performance_tuning.html

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.