[Pkg-postgresql-public] Bug#730134: Compile with -fno-omit-frame-pointer to enable generation of hierarchical profiles

[Andres Freund]

Package:postgresql-common
Version: 150
Severity: wishlist

When using postgres it can often be very advantageous to analyze where
it is spending its time and perf is very helpful tool for
that. Unfortunately it is hard to properly use that information unless
the profile is hierarchical (perf record -g), which requires binaries
compiled with -fno-omit-frame-pointer.
On x86-64, which is not as register starved as x86, the performance
impact is close to unnoticeable, at least for postgres.

So I suggest compiling postgres with -fno-omit-frame-pointer on x86-64,
but not on other platforms.

Greetings,

Andres Freund