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 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

I was forgetting: - gcc (GCC) 10.2.1 20200723 (Red Hat 10.2.1-1) - clang version 10.0.0 (Fedora 10.0.0-2.fc32) - Potentially usable by "-march=skylake -mtune=skylake": flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch cpuid_fault epb invpcid_single pti ssbd ibrs ibpb stibp tpr_shadow vnmi flexpriority ept vpid ept_ad fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid mpx rdseed adx smap clflushopt intel_pt xsaveopt xsavec xgetbv1 xsaves dtherm ida arat pln pts hwp hwp_notify hwp_act_window hwp_epp md_clear flush_l1d On Tue, 15 Sep 2020 at 17:03, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

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. Roberto

On Tue, 15 Sep 2020 at 16:32, Sjoerd Mullender 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