PostgreSQLv14 TPC-H performance GCC vs Clang

From: arjun shetty <arjunshetty955(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: PostgreSQLv14 TPC-H performance GCC vs Clang
Date: 2021-11-02 17:13:22
Message-ID: CAMowxTu2S4BY4a4cRYyoyY8LqJWq1MPH+ACnzXu8H_AtBJxcTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi
PostgreSQLv14 source code build with GCCv11.2 and Clangv12(without JIT)
with optimisation flags like O3 and tested with HammerDB
Observed TPC-H , GCC performance better than Clang(without JIT). The
performance difference ~22% and also noticed the assembly code difference
GCC vs Clang( e.g. GCC inlined functionality compared to Clang).

Environment details:
————————-
OS :RHEL8.4
Bare metal : Apple/AMD EPYC/IBM
Test(TPC-H) Benchmark Environment:HammerDB

Is the performance difference mainly because of below points ?
1 data over flow and calculations like int128(int128.c) and C arithmetic
operations(functions include in float.h e.g float4_mul)

And please suggest is any another functionality or code points need to
check on the performance difference

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Imre Samu 2021-11-02 19:29:23 Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Previous Message Tim Slechta 2021-10-28 15:00:31 Re: Views don't seem to use indexes?