The preliminary port to neo4j indicated it was 10x slower than postgres. I don't know the technical reason for this, it might just be due to a bad design. Perhaps a good coder could fix this up.
Other nosql databases tend to be optimized for caching web pages or images, which are 10KBytes or larger (megabytes), and have absolutely terrible performance when the stored objects are just a few hundred bytes. The opencog atoms are, for the most part, about 50-100 bytes in size, when stored. postgres has sophisticated query mechanisms which most nosql databases do not support. Opencog uses one of these, to quickly locate atoms at the end of graph edges. So these two requirements: ability to walk graph edges, and to be efficient/fast for small objects, are currently the main requirements. MariaDB can't do the first, and most nosql cant do the second. --linas On Mon, May 8, 2017 at 4:19 PM, Dmitry Ponyatov <[email protected]> wrote: > I see odbc-postgresql & postgresql-client @ https://github.com/opencog/ > ocpkg/blob/master/debian/install-debian-dependencies.sh > > I'm surprised why pgsql used ? > opencog nature tends to use some noSQL graph databases like neo4j > > -- > You received this message because you are subscribed to the Google Groups > "opencog" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/opencog. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/opencog/9fa7463c-756c-4639-a16f-ebe71abd3086%40googlegroups.com > <https://groups.google.com/d/msgid/opencog/9fa7463c-756c-4639-a16f-ebe71abd3086%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 "opencog" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/opencog. To view this discussion on the web visit https://groups.google.com/d/msgid/opencog/CAHrUA36qj05RoQjZswYJ1-p22g_S9r4%2BRXJG90nymaFayMaW6Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
