Hi Yury I'm really surprised that it would be taking 24 hours for indexing, when you've got this database index. I'm afraid I'm not as familiar with debugging Postgres as I am with MySQL - what's the equivalent of an EXPLAIN query in Postgres?
Also, just to double-check - can you put your db/schema.rb file in a gist and share that with us? Or, if you don't want to make that public, feel free to email me (instead of the list) with the link directly. Cheers -- Pat On 16/10/2010, at 8:51 AM, Yury Kotlyarov wrote: > 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. > -- 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.
