In general use elasticsearch only as a secondary index. Have a copy of data somewhere else which is more reliable. Elasticsearch often runs into index corruption issues which are hard to resolve.
On Mon, Aug 25, 2014 at 9:30 PM, <[email protected]> wrote: > > On Tuesday, August 26, 2014 6:46:12 AM UTC+8, Raphael Waldmann wrote: >> >> Hi, >> >> First I would like to thanks all of you for Elastic. I am thinking in use >> it in a ERP that I am building. What do you think about this? Am I crazy? >> >> Has someone face this? I really don't think that I am comfy enough to do >> this, change the problems that I already know, for new problems that I >> really don't know how to deal. >> >> I believe that nosql will prevail over traditional sql, but I don't know >> if I am ready to this task. >> >> So how you think that I should integrate (or not) postgresql with >> ELASTICSEARCH? >> > > Will you plan t use ES to index data in postgresql? > > I have similar idea, want to use ES instead datawarehouse. > > Some problems I can see: > 1) Data in RDBMS are stored in tables, connected with relationship. You > can use very complex sql to query a complex result, how to do in ES? > 2) If your want to run some analyse algorithms with exist data, how to > running in ES? > 3) if your data are enough big, search one keyword in '_all' field, ES > will be slow? > > > Thanks. > -Terrs > > Thanks again, >> >> >> rsw1981 >> > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/f5500235-46e8-4c6c-8597-e42d7401d22a%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/f5500235-46e8-4c6c-8597-e42d7401d22a%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAOT3TWqoEZHchXCU7p%3DNt9FtibQyCiWwU6nt9YQNUATiOspMVQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
