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.

Reply via email to