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

[erik.forsberg]

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