From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: arjun shetty <arjunshetty955@gmail.com>
To: Imre Samu <pella.samu@gmail.com>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Date: Fri, 5 Nov 2021 18:29:37 +0100
Message-ID: <69584b92-7405-8d65-adb5-175439b3f95e@enterprisedb.com> (raw)
In-Reply-To: <CAMowxTvTQxS+fzWM5LPzHaq6POR=n5t1aYdch-JZ0YezVb=Qjw@mail.gmail.com>
References: <CAMowxTu2S4BY4a4cRYyoyY8LqJWq1MPH+ACnzXu8H_AtBJxcTA@mail.gmail.com>
<CAJnEWwmj+sC32bnUYr6-sTBuQ39dbwzRcWTmA2fhiB9u8kDGeA@mail.gmail.com>
<CAMowxTvTQxS+fzWM5LPzHaq6POR=n5t1aYdch-JZ0YezVb=Qjw@mail.gmail.com>
Hi,
IMO this thread provides so little information it's almost impossible to
answer the question. There's almost no information about the hardware,
scale of the test, configuration of the Postgres instance, the exact
build flags, differences in generated asm code, etc.
I find it hard to believe merely switching from clang to gcc yields 22%
speedup - that's way higher than any differences we've seen in the past.
In my experience, the speedup is unlikely to be "across the board".
There will be a handful of affected queries, while most remaining
queries will be about the same. In that case you need to focus on those
queries, see if the plans are the same, do some profiling, etc.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tomas.vondra@enterprisedb.com, arjunshetty955@gmail.com, pella.samu@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: PostgreSQLv14 TPC-H performance GCC vs Clang
In-Reply-To: <69584b92-7405-8d65-adb5-175439b3f95e@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox