citus_docs icon indicating copy to clipboard operation
citus_docs copied to clipboard

Improve query performance tuning section

Open begriffs opened this issue 7 years ago • 1 comments

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

begriffs avatar Sep 13 '18 18:09 begriffs

Explain output is diverged from current version. We should re-run and update here

mtuncer avatar Dec 13 '18 16:12 mtuncer