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 06:59:04 -0400 |
| commit | 88336fdbb5e101fa25825b737169c0d6af2faa93 (patch) | |
| tree | 208e2b3cb2a8aa8cdc9f0614abb03228b8b6fb84 /docs/ref/models | |
| parent | 504e7782fef74cb78768092780a3476866379c21 (diff) | |
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.
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 867ce47ce3..38c6d84b0b 100644 --- a/docs/ref/models/querysets.txt +++ b/docs/ref/models/querysets.txt @@ -2026,6 +2026,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. |