Hi Yury That's definitely not ideal... have you got a database index on your foreign key? (ie: something like the following in your migrations): add_index :pages, :node_id
Cheers -- Pat On 09/10/2010, at 2:16 AM, Yury Kotlyarov wrote: > Hi, > > I have two models: Node and Page. 4k nodes and 400k pages in postgres, > each node has 500+ pages, page.full_text: 1+ kB. > > Node: > > has_many :pages > > define_index do > indexes pages.full_text, :as => :page_full_text > end > > rake ts:index is running 24 hours and ate 20 GB (in /var/lib/ > postgresql/8.4/data/base/pgsql_tmp/ dir) > > Is it correct behaviour? > > Btw if I index pages by Page's index it takes not more that 15 mins. > > > TIA, > Yury > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
