DefaultOfBizListIterator reads the full result set into memory under Postgres and possibly other database implementations

XMLWordPrintable

    • 5

      During a re-index all issues are read using the DefaultOfBizListIterator, because this is implemented outside a transaction PostgreSQL does not use a server side cursor and so reads the complete result set containing all issues into memory consuming excessive amounts of memory in the process.

      Other databases may behave similarly.

            Assignee:
            Eric Dalgliesh
            Reporter:
            Trevor Campbell (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: