On Fri, Oct 25, 2013 at 12:29 PM wrote: > Our setup is as follows: > > * We run Sphinx > * We have delta-indexing with ts-resque-delta > * We run "rake thinking_sphinx:index" once every night > > My question is: Is running "rake thinking_sphinx:index" every night needed > with this setup?
Depending on database size and how often data adding and updating. I have: # du -sh /var/lib/pgsql/data 12G /var/lib/pgsql/data # I am using realtime delta indexes. After week, I see little degradation in search speed. I expect that after month without reindex it will be slow in two times (I don't measure it). So, I am reindex data every night. Any way, it takes 7 minutes in my case. > * Is there some kind of cleanup or shuffling of data between core <-> delta > indexes that needs to be done regularly when you have delta-indexing that is > performed by running the Rake-task every night? > * Can it be run more seldom? What are the possible tradeoffs, in that case? > > Thank you very much! -- Igor Zubkov http://hi.im/ice -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
