On Fri, Nov 4, 2011 at 3:14 PM, Matt Jones <[email protected]> wrote:
> The challenge here is that there's no DB (that I'm aware of) that can > meaningfully index regexes, meaning that every query against the table > is going to be a full table scan. How bad that is depends on how big > your table is: Postgres can handle this kind of lookup, though it is more complex than the normal situation. Postgres uses customisable indexes, so you can specify things exactly as you need for specific lookups. https://github.com/dimitri/prefix -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
