From 88336fdbb5e101fa25825b737169c0d6af2faa93 Mon Sep 17 00:00:00 2001 From: François Freitag Date: Fri, 5 May 2017 19:19:34 -0700 Subject: 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. --- docs/ref/models/querysets.txt | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'docs/ref/models') 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 ` 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 ` +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. -- cgit v1.3