[midPoint-git] [Evolveum/midpoint] 437847: Added indexes on m_audit_item(record_id) and m_aud...

Radovan Semancik radovan.semancik at evolveum.com
Wed Apr 5 13:35:47 CEST 2017


  Branch: refs/heads/feature/manual-connectors
  Home:   https://github.com/Evolveum/midpoint
  Commit: 43784759a3e891c2cd382f830cb9625c17f5a820
      https://github.com/Evolveum/midpoint/commit/43784759a3e891c2cd382f830cb9625c17f5a820
  Author: ggallard <ggallard at identicum.com>
  Date:   2017-04-04 (Tue, 04 Apr 2017)

  Changed paths:
    M config/sql/_all/postgresql-3.5-all.sql

  Log Message:
  -----------
  Added indexes on m_audit_item(record_id) and m_audit_delta(record_id)

PostgreSQL does not create automatic indexes on foreign key columns.
Delete from parent table is very slow because of full scan on the record_id columns of the child tables.


  Commit: 2f27235e869cf90752c923eb024d917258c0d282
      https://github.com/Evolveum/midpoint/commit/2f27235e869cf90752c923eb024d917258c0d282
  Author: Radovan Semancik <radovan.semancik at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M config/sql/_all/postgresql-3.5-all.sql

  Log Message:
  -----------
  Merge pull request #25 from Identicum/master

Added indexes on m_audit_item(record_id) and m_audit_delta(record_id)


  Commit: 39e1149e3162f9f3bada1980104f777aa8315ebf
      https://github.com/Evolveum/midpoint/commit/39e1149e3162f9f3bada1980104f777aa8315ebf
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/controller/ModelDiagController.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/AdHocDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModel.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizer.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizerImpl.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/MappingRelation.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/Relation.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/RepositoryDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/ResourceDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/VisualizationContext.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotAdHocDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotMappingRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotModel.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotOtherRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotRepositoryDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotResourceDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/AdHocDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/DataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/MappingRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/Relation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/RepositoryDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/ResourceDataItem.java

  Log Message:
  -----------
  Refactored data model visualization code a bit (separated DOT-specific code from generic one).


  Commit: 951c802364a1f097de700f2d06be97a6eb489b33
      https://github.com/Evolveum/midpoint/commit/951c802364a1f097de700f2d06be97a6eb489b33
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizerImpl.java

  Log Message:
  -----------
  Fixed TestModelVisualization.


  Commit: e7d85428aafe31194d3d3604e88b870f61a6fdbb
      https://github.com/Evolveum/midpoint/commit/e7d85428aafe31194d3d3604e88b870f61a6fdbb
  Author: Pavol Mederly <mederly at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M gui/admin-gui/src/main/java/com/evolveum/midpoint/web/page/admin/resources/PageResourceVisualization.java
    A model/model-api/src/main/java/com/evolveum/midpoint/model/api/DataModelVisualizer.java
    M model/model-api/src/main/java/com/evolveum/midpoint/model/api/ModelDiagnosticService.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/controller/ModelDiagController.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizer.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizerImpl.java
    M model/model-intest/src/test/java/com/evolveum/midpoint/model/intest/TestModelVisualization.java

  Log Message:
  -----------
  Fixed data model visualization API.


  Commit: a3b1cf033f8502d76919129870141a38e9e7b67e
      https://github.com/Evolveum/midpoint/commit/a3b1cf033f8502d76919129870141a38e9e7b67e
  Author: jan.melnik <jan.melnik at ami.cz>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M gui/admin-gui/src/main/resources/localization/Midpoint.properties

  Log Message:
  -----------
  web.security.ldap.* English mappings. Text taken from web.security.provider.* (Some texts should probably be modified to inform user about back-end authentication provider.)


  Commit: 1f6dba57e9ea1478aa40a653ab8337867a526724
      https://github.com/Evolveum/midpoint/commit/1f6dba57e9ea1478aa40a653ab8337867a526724
  Author: Martin Lízner <martin.lizner at gmail.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M gui/admin-gui/src/main/resources/localization/Midpoint.properties

  Log Message:
  -----------
  Merge pull request #26 from littleBigMen/master

web.security.ldap.* English mappings


  Commit: 50a117a6a64f6b831014ed4468a8549bacd4b741
      https://github.com/Evolveum/midpoint/commit/50a117a6a64f6b831014ed4468a8549bacd4b741
  Author: Radovan Semancik <radovan.semancik at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M infra/prism/src/main/resources/xml/ns/public/types-3.xsd

  Log Message:
  -----------
  Changing schema validation to lax


  Commit: de17b0d5ebcc93439c6dff1e94af97b1aea3e580
      https://github.com/Evolveum/midpoint/commit/de17b0d5ebcc93439c6dff1e94af97b1aea3e580
  Author: Radovan Semancik <radovan.semancik at evolveum.com>
  Date:   2017-04-05 (Wed, 05 Apr 2017)

  Changed paths:
    M config/sql/_all/postgresql-3.5-all.sql
    M gui/admin-gui/src/main/java/com/evolveum/midpoint/web/page/admin/resources/PageResourceVisualization.java
    M gui/admin-gui/src/main/resources/localization/Midpoint.properties
    M infra/prism/src/main/resources/xml/ns/public/types-3.xsd
    A model/model-api/src/main/java/com/evolveum/midpoint/model/api/DataModelVisualizer.java
    M model/model-api/src/main/java/com/evolveum/midpoint/model/api/ModelDiagnosticService.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/controller/ModelDiagController.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/AdHocDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModel.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizer.java
    M model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/DataModelVisualizerImpl.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/MappingRelation.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/Relation.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/RepositoryDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/ResourceDataItem.java
    R model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/VisualizationContext.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotAdHocDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotMappingRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotModel.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotOtherRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotRepositoryDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/dot/DotResourceDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/AdHocDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/DataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/MappingRelation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/Relation.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/RepositoryDataItem.java
    A model/model-impl/src/main/java/com/evolveum/midpoint/model/impl/dataModel/model/ResourceDataItem.java
    M model/model-intest/src/test/java/com/evolveum/midpoint/model/intest/TestModelVisualization.java

  Log Message:
  -----------
  Merge branch 'master' into feature/manual-connectors


Compare: https://github.com/Evolveum/midpoint/compare/33bd4c752c25...de17b0d5ebcc


More information about the midPoint-svn mailing list