Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-9975

Use PostgreSQL unlogged table for cache tables

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6-RC3
    • Fix Version/s: 5.7.1
    • Component/s: Core VCS
    • Environment:
      PostgreSQL
    • Tags:
    • Upgrade notes:
      Hide

      To take effect on existing instance, acl_user, acl_user_map and aclr_modified tables need to be droped.

      Show
      To take effect on existing instance, acl_user, acl_user_map and aclr_modified tables need to be droped.

      Description

      Some tables will benefit from the new UNLOGGED table available since PostgreSQL 9.1,

      for instances cache tables:

      • aclr_user which contains the list of logged users
      • aclr_user_map which contains the list of read acls for logged users

      http://www.postgresql.org/docs/9.1/static/sql-createtable.html

        Attachments

          Activity

            People

            • Assignee:
              bdelbosc Benoit Delbosc
              Reporter:
              bdelbosc Benoit Delbosc
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: