misc/migration/3.17.11_Any.py
author Julien Cristau <julien.cristau@logilab.fr>
Wed, 13 Nov 2013 12:39:30 +0100
branchstable
changeset 9336 722635e530a0
child 9463 d62e13eba033
permissions -rw-r--r--
[server] Add missing indices for undo support (closes #3259691) The tables used by the 'undo' feature were missing some indices, which among other things triggered repeated sequential scans when deleting old transactions.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
9336
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     1
for table, column in [
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     2
        ('transactions', 'tx_time'),
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     3
        ('tx_entity_actions', 'tx_uuid'),
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     4
        ('tx_relation_actions', 'tx_uuid')]:
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     5
    session.cnxset.source('system').create_index(session, table, column)
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     6
722635e530a0 [server] Add missing indices for undo support (closes #3259691)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     7
commit()