Although still unfinished, I can informally share some results from benchmarking MonetDB as follows (pseudo-bash).for RELEASE in Nov2019 Jun2020
for CC in gcc clang
for OPT in "-O2" "-O3"
for ARCH in "" "-march=skylake -mtune=skylake" # "" = default, "skylake"=the architecture I tested on
# compile ...
for WORKLOAD in tpc-h text spinque
for COMPILATION in (those above)
for OPT_PIPE in default_pipe no_mitosis_pipe sequential_pipe
for RUN in cold hot
# test ...This was on a 16GB 4-core i7 with SSD disk.As for workloads, tpc-h was sf 10, "text" is a benchmark on string-oriented functionalities (tokenization, string similarity, etc.), and "spinque" (still to be expanded) is a small collection of real queries that we run on Spinque - very long and nested generated SQL queries, rich of aggregations and string operations, typically on skewed data distributions.I wanted to write a nice blog about these experiments, but if things stay as they are it would be a very boring blog.This is my main finding so far: while the choice of optimization pipeline can have a big impact on some queries (for some queries mitosis helps a lot, for others is a real pain),I have found NO significant difference amongst all the compilation options, in no workload.I hope it helps.RobertoOn Tue, 15 Sep 2020 at 16:32, Sjoerd Mullender <sjoerd@monetdb.org> wrote:The MonetDB.spec file is part of the source tree, so you can take a look
there.
It basically uses the default for CentOS 7. Try:
rpm -E %optflags
to see what the default flags are on CentOS 7.
On 15/09/2020 15.46, Brian Hood wrote:
> Hi Daniel,
>
> I would probably download some source packages like SRPMS or whatever
> the DEB equivalent is and have a look at the configure options in them.
>
> Regards,
>
> Brian Hood
>
> On Tue, 1 Sep 2020 at 16:28, Daniel Glöckner <gloeckner.daniel@gmail.com
> <mailto:gloeckner.daniel@gmail.com>> wrote:
>
> Hi,
>
> I'm currently building and testing MonetDB on CentOS7, x86_64.
>
> I was wondering about the recommended compiler version and compiler
> flags.
>
> So far I'm using gcc 9 and specifically enabled SSE3 extensions
> (though I did not notice any performance gain).
>
> Here's my cmake command
> cmake3 -DCMAKE_C_FLAGS="pthread -msse3 -O -Wall"
> -DCMAKE_INSTALL_PREFIX=../install ../MonetDB
>
> Is there a list of recommended compiler flags?
>
> Kind regards,
> Daniel
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org <mailto:users-list@monetdb.org>
> https://www.monetdb.org/mailman/listinfo/users-list
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
--
Sjoerd Mullender
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list