Announcement

Collapse
No announcement yet.

Postindex table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Postindex table

    Hello,

    I was wondering what is postindex table for?

    I have 675 mb db which is total pain to restore. I see that postindex table is 473 mb. Which is biggest table. I guess it is some kind of search cache.

    Is it ok if i truncate that table, restore it than rebuild search index?

  • #2
    That is used as the search index for the default vBulletin search engine. You don't need to rebuild it unless you are changing the search word length or you are reindexing after a large prune or something.

    I recommend using the fulltext search engine:

    Admin CP -> vBulletin Options -> Search Type (on the left, not the right)

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X