Thanks for the response, Pat - yes, it's the same index as the other thread. Good point about sorting resumes, that shouldn't be there. However, why would that make such a difference between TS2 and TS3 (see my other post which I added at the same time as your response)?
I will try removing the sortable on resumes and see what difference it makes! On Thursday, July 18, 2013 1:49:13 PM UTC-4, Pat Allan wrote: > > Hi Daniel > > If this is the same index as in the other thread, I'm guessing it's the > fact that you've got resumes.document sortable. A record with many resumes > and/or large document values could end up with massive values for the > underlying string attribute (that you'd sort by) - are you actually sorting > by this? Generally I'd be surprised if there's much point sorting by large > amounts of text. > > -- > Pat > > On 19/07/2013, at 3:09 AM, Daniel Vandersluis wrote: > > > Is there any reason that an index would grow in size when upgrading from > thinkingsphinx 2 to 3? The only differences in the configuration file is > changing port to mysql41, and changing version to 2.0.8-release, but an > index that used to be around 500MB is now resulting in this error: > > > > ERROR: index 'user_core': too many string attributes (current index > format allows up to 4 GB). > > > > Anyone have any idea why this would be? > > > > -- > > 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] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/thinking-sphinx. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > > -- 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.
