Mercurial > p > roundup > code
diff roundup/configuration.py @ 6332:6a6b4651be1f
Use server-side cursor for postgres in some cases
In filter, filter_iter, and _materialize_multilinks, use named cursor
with postgresql. This turns of client-side cursor handling and avoids
*large* roundup process (or wsgi process) in case of large results.
Fixes issue2551114.
| author | Ralf Schlatterbeck <rsc@runtux.com> |
|---|---|
| date | Thu, 04 Mar 2021 12:55:21 +0100 |
| parents | 778a9f455067 |
| children | bd84f43e1d13 |
line wrap: on
line diff
--- a/roundup/configuration.py Tue Mar 02 12:43:19 2021 -0500 +++ b/roundup/configuration.py Thu Mar 04 12:55:21 2021 +0100 @@ -1082,6 +1082,10 @@ "Database isolation level, currently supported for\n" "PostgreSQL and mysql. See, e.g.,\n" "http://www.postgresql.org/docs/9.1/static/transaction-iso.html"), + (BooleanOption, "serverside_cursor", "yes", + "Set the database cursor for filter queries to serverside\n" + "cursor, this avoids caching large amounts of data in the\n" + "client. This option only applies for the postgresql backend."), ), "Settings in this section (except for backend) are used" " by RDBMS backends only." ),