Greetings!
We have been testing MonetDB for use in AWS in the
last couple of weeks and we are surprised with its overall performance,
even when dealing with large tables and under-powered machines. Still,
we were wondering if its possible in anyway to improve the performance
by distributing the databases/tables through several machines. While
looking at MonetDB documentation and the mailing list archives, I get
some mixed answers about this topic and nothing very concrete.
We noticed that it's possible to create a cluster of MonetDB
instances, but it seems that it's main purpose is to ease the
administration of several MonetDB instances and provide a single
entrance point to several MonetDB instances. Still, we still have some
questions about its use:
Is it possible to partition a table across several MonetDB instances in order to improve the performance?
Best regards,
Pedro Salgueiro