sure, I have this index On 15 окт, 06:24, Pat Allan <[email protected]> wrote: > 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 > > athttp://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.
