Hi,
PostgreSQLv14- compiled with LLVM-Clangv13 and GCCv11,And captured
performance using HammerDBv4.3-TPC-H.
And Observed the functionality differences as LLVM-Clangv13-triggers
heapgetpage instead XidInMVCCSnapshot or vice versa with GCC.
I would like to know here the functionality differences tr
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
s result file with the Phoronix Test
> Suite
> by running the command: phoronix-test-suite benchmark
> 2105299-IB-COMPILERT91"
>
> Regards.
> Imre
>
> arjun shetty ezt írta (időpont: 2021. nov. 2.,
> K, 18:13):
>
>> Hi
>> PostgreSQLv14 source co
Yes, currently focusing affects queries as well.
In meanwhile on analysis(hardware level) and sample examples noticed
1. GCC performance better than Clang on int128 .
2. Clang performance better than GCC on long long
the reference example
https://stackoverflow.com/questions/63029428/why-is-int128
Hi Askhil
PostgreSQL utilizes lightweight locks(LWLocks) to synchronize and control
access to the buffer content. A process acquires an LWLock in a shared
mode to read from the buffer and an exclusive mode to write to the buffer.
Therefore, while holding an exclusive lock, a process prevents ot
, arjun shetty
wrote:
> Hi Askhil
>
> PostgreSQL utilizes lightweight locks(LWLocks) to synchronize and
> control access to the buffer content. A process acquires an LWLock in a
> shared mode to read from the buffer and an exclusive mode to write to
> the buffer. Therefore, while ho
Hi ,
PostgreSQLv14 source build/compiled with GCCv11.1 and bin's run different
machine like single machine and client-server machine.
observed Single Milan machine, the NOPM is more or less half with the
Client-Server method.
And checked the network bandwidth on Client-Server machine, it is simi
status/1466808507240386560
> -
> https://www.phoronix.com/scan.php?page=news_item&px=LLVM-Clang-14-Hoist-Load
>
> regards,
> Imre
>
>
>
> arjun shetty ezt írta (időpont: 2021. nov.
> 16., K, 11:10):
>
>> Yes, currently focusing affects queries as well.
>>
