Comment 2 for bug 771956

Revision history for this message
Chris Rossi (chris-archimedeanco) wrote :

My plan for this is take the 'use_pgtextindex' script and turn it into a 'reindex_text' script. This script would, by default, rebuild a text index of the same type already in use or if specified by a flag (--pg or --zope) will build a new text index of the type specified, allowing the user to switch arbitrarily between text index types.

The difficult part, such as it is, has already been written. The script already builds a new text index in parallel with the existing one so as not to interrupt normal site operations. It also indexes documents in batches using several transactions to prevent overconsumption of memory on large sites like OSF. An upshot of this approach is the script can be interrupted and resumed.

So the only new work is just renaming the script and adding the options to create either a zope text index or a pg text index when doing the reindex. Should be a very quick job.