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

[Radovan Semancik]

  Branch: refs/heads/master
  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)


Compare: https://github.com/Evolveum/midpoint/compare/8289f770f8c4...2f27235e869c