No subject

Andrew's Avatar


01 Jul, 2013 01:22 PM

My app has a very large database (100M+ records) on RDS and I would like to index only a portion of them in my local development environment. It simply takes too long, and too often times out, when I try to index the entire thing using rake ts:rebuild. How can I do this? Thanks.

  1. Support Staff 1 Posted by Pat Allan on 01 Jul, 2013 01:42 PM

    Pat Allan's Avatar

    Hi Andrew

    You can add a WHERE clause to your index definition:

    This will allow you to limit your index data to just a small amount.

    Are you seeing issues when indexing via Flying Sphinx as well? Or just locally?


Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac