pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)?
3+ messages / 3 participants
[nested] [flat]
* BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)?
@ 2021-09-22 13:17 PG Bug reporting form <noreply@postgresql.org>
2021-09-28 06:15 ` Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? hpc researcher_mspk <hpcresearch.mspk@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2021-09-22 13:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: hpcresearch.mspk@gmail.com
The following bug has been logged on the website:
Bug reference: 17200
Logged by: hpc researcher
Email address: hpcresearch.mspk@gmail.com
PostgreSQL version: 13.3
Operating system: RHEL8.4
Description:
I followed the below steps on Profile Guide Optimization with Clang
Environment.
And benchmark environment used HammedDB.
1.Build command:
------------
$ CC=clang CXX=clang++ ../configure --prefix=<path-to-install> CFLAGS='-O3
-fprofile-instr-generate' CXXFLAGS='-O3 -std=c++14 -stdlib=libc++
-fprofile-instr-generate'
2.Run HammerDB client(tpcc-schmea + test run(vu's).
3. default.profraw created in PostgreSQL(<path-to-install>)
4. convert the “raw” profile format by clang.(the merge
command:llvm-profdata tool)
5. llvm-profdata merge -output=code.profdata code- default.profraw
warning: default.profraw: Failed to uncompress data (zlib)
error: No profiles could be merged.(step5)
Ref:
https://clang.llvm.org/docs/UsersManual.html#profiling-with-instrumentation
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)?
2021-09-22 13:17 BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? PG Bug reporting form <noreply@postgresql.org>
@ 2021-09-28 06:15 ` hpc researcher_mspk <hpcresearch.mspk@gmail.com>
2021-09-28 13:39 ` Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: hpc researcher_mspk @ 2021-09-28 06:15 UTC (permalink / raw)
To: hpcresearch.mspk@gmail.com; pgsql-bugs@lists.postgresql.org
Tried PostgreSQL with GCC-Profile guided optimization(PGO) and it is
working with the HammerDB benchmark environment. Similarly, we tried
PostgreSQL with Clang(12.0V) -Profile guided optimization(PGO) and it is
not working and observed an error
"warning: default.profraw: Failed to uncompress data (zlib)
error: No profiles could be merged"
Reference bug #: 17200
Are there any plans to fix this issue in upcoming releases? Otherwise,
could you please provide us a workaround/patch for this issue?
On Wed, 22 Sept 2021 at 18:48, PG Bug reporting form <noreply@postgresql.org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17200
> Logged by: hpc researcher
> Email address: hpcresearch.mspk@gmail.com
> PostgreSQL version: 13.3
> Operating system: RHEL8.4
> Description:
>
> I followed the below steps on Profile Guide Optimization with Clang
> Environment.
> And benchmark environment used HammedDB.
>
> 1.Build command:
> ------------
> $ CC=clang CXX=clang++ ../configure --prefix=<path-to-install>
> CFLAGS='-O3
> -fprofile-instr-generate' CXXFLAGS='-O3 -std=c++14 -stdlib=libc++
> -fprofile-instr-generate'
> 2.Run HammerDB client(tpcc-schmea + test run(vu's).
> 3. default.profraw created in PostgreSQL(<path-to-install>)
> 4. convert the “raw” profile format by clang.(the merge
> command:llvm-profdata tool)
> 5. llvm-profdata merge -output=code.profdata code- default.profraw
> warning: default.profraw: Failed to uncompress data (zlib)
> error: No profiles could be merged.(step5)
>
> Ref:
> https://clang.llvm.org/docs/UsersManual.html#profiling-with-instrumentation
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)?
2021-09-22 13:17 BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? PG Bug reporting form <noreply@postgresql.org>
2021-09-28 06:15 ` Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? hpc researcher_mspk <hpcresearch.mspk@gmail.com>
@ 2021-09-28 13:39 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2021-09-28 13:39 UTC (permalink / raw)
To: hpc researcher_mspk <hpcresearch.mspk@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
hpc researcher_mspk <hpcresearch.mspk@gmail.com> writes:
> Tried PostgreSQL with GCC-Profile guided optimization(PGO) and it is
> working with the HammerDB benchmark environment. Similarly, we tried
> PostgreSQL with Clang(12.0V) -Profile guided optimization(PGO) and it is
> not working and observed an error
> "warning: default.profraw: Failed to uncompress data (zlib)
> error: No profiles could be merged"
> Are there any plans to fix this issue in upcoming releases?
I see no reason to believe that this is Postgres' problem to fix.
Try filing a bug with the Clang people.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-09-28 13:39 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-22 13:17 BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? PG Bug reporting form <noreply@postgresql.org>
2021-09-28 06:15 ` hpc researcher_mspk <hpcresearch.mspk@gmail.com>
2021-09-28 13:39 ` Tom Lane <tgl@sss.pgh.pa.us>
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