Mercurial > p > roundup > code
diff roundup/backends/back_postgresql.py @ 2745:b284ff7af3fb
add optimised index on postgresql text index table
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 08 Oct 2004 08:10:37 +0000 |
| parents | 402d6d556558 |
| children | a7045bad20de |
line wrap: on
line diff
--- a/roundup/backends/back_postgresql.py Fri Oct 08 07:22:04 2004 +0000 +++ b/roundup/backends/back_postgresql.py Fri Oct 08 08:10:37 2004 +0000 @@ -151,6 +151,11 @@ self.sql('CREATE INDEX %ss_key_idx ON %ss(%s_key)'%(name, name, name)) + def fix_version_3_tables(self): + rdbms_common.Database.fix_version_3_tables(self) + self.sql('''CREATE INDEX words_both_idx ON public.__words + USING btree (_word, _textid)''') + def add_actor_column(self): # update existing tables to have the new actor column tables = self.database_schema['tables']