[Python-checkins] r57316 - tracker/roundup-src/roundup/backends/back_postgresql.py

Thu Aug 23 15:28:08 CEST 2007

Author: erik.forsberg
Date: Thu Aug 23 15:28:07 2007
New Revision: 57316
Modified:
 tracker/roundup-src/roundup/backends/back_postgresql.py
Log:
Apply
http://permalink.gmane.org/gmane.comp.bug-tracking.roundup.devel/4609
- it makes import go much faster. Fixes
http://psf.upfronthosting.co.za/roundup/meta/issue131.
Modified: tracker/roundup-src/roundup/backends/back_postgresql.py
==============================================================================

--- tracker/roundup-src/roundup/backends/back_postgresql.py	(original)
+++ tracker/roundup-src/roundup/backends/back_postgresql.py	Thu Aug 23 15:28:07 2007
@@ -161,6 +161,9 @@
 self.sql('''CREATE TABLE __words (_word VARCHAR(30), 
 _textid integer)''')
 self.sql('CREATE INDEX words_word_idx ON __words(_word)')
+ self.sql('CREATE INDEX words_by_id ON __words (_textid)')
+ self.sql('CREATE UNIQUE INDEX __textids_by_props ON '
+ '__textids (_class, _itemid, _prop)')
 
 def fix_version_2_tables(self):
 # Convert journal date column to TIMESTAMP, params column to TEXT
