diff options
| author | François Freitag <mail@franek.fr> | 2017-05-05 19:19:34 -0700 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2017-05-06 07:45:46 -0400 |
| commit | 6a2624286b0501942522726bfdcb18537a86ce7c (patch) | |
| tree | 33aa0c697909c1ea4015860ef32144c6e4da750f /docs/ref/models | |
| parent | f9a459337672a2094c61cb53ce8626ace7101a09 (diff) | |
[1.11.x] Fixed #28062 -- Added a setting to disable server-side cursors on PostgreSQL.
When a connection pooler is set up in transaction pooling mode, queries
relying on server-side cursors fail. The DISABLE_SERVER_SIDE_CURSORS
setting in DATABASES disables server-side cursors for this use case.
Backport of 88336fdbb5e101fa25825b737169c0d6af2faa93 from master
Diffstat (limited to 'docs/ref/models')
| -rw-r--r-- | docs/ref/models/querysets.txt | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/docs/ref/models/querysets.txt b/docs/ref/models/querysets.txt index 1d6a406cce..d49a2d27eb 100644 --- a/docs/ref/models/querysets.txt +++ b/docs/ref/models/querysets.txt @@ -2041,6 +2041,11 @@ won't cache results after iterating over them. Oracle and :ref:`PostgreSQL <postgresql-server-side-cursors>` use server-side cursors to stream results from the database without loading the entire result set into memory. +On PostgreSQL, server-side cursors will only be used when the +:setting:`DISABLE_SERVER_SIDE_CURSORS <DATABASE-DISABLE_SERVER_SIDE_CURSORS>` +setting is ``False``. Read :ref:`transaction-pooling-server-side-cursors` if +you're using a connection pooler configured in transaction pooling mode. + .. versionchanged:: 1.11 PostgreSQL support for server-side cursors was added. |