Kinto / kinto / 40676070624

100%

master: 100%

push

github

Document optional PostgreSQL indexes for performance tuning (#3802)

* Document optional PostgreSQL indexes for performance tuning

The GIN index that accelerates JSONB filters, and expression indexes for sorting, were only mentioned in the Storage class docstring (see #3646). Add a user-facing section to the production docs, as suggested in #3652.

* docs: link index tuning from storage backend

* docs: remove psycopg binding implementation detail

Keep the compatibility concern tracked in #3648.

* docs: guide index tuning with pg_stat_statements

---------

Co-authored-by: hkwongax <hkwongax@users.noreply.github.com>

1611 of 1611 branches covered (100.0%)

8262 of 8262 relevant lines covered (100.0%)

3.0 hits per line