Percona Postgres distribution has "debug_assertions" enabled

[lglauer]

Description

Percona Postgres distribution has debug_assertions enabled (--enable-cassert) leading to major performance degradation in production environments. I noticed this problem after an docker image upgrade from 16.6 to 16.11.

Performance comparison between different versions for the same internal workload:

• Percona Postgres 16.6 with debug_assertions "off":
  p10: 194 ms
  p50: 237 ms
  p90: 276 ms
  p95: 289 ms
  p99: 339 ms

• Percona Postgres 16.11 with debug_assertions "on":
  p10: 293 ms
  p50: 335 ms
  p90: 376 ms
  p95: 394 ms
  p99: 470 ms

Mean (p50) latency for the same workload increased by more than 41%!

Expected Results

debug_assertions must not be enabled for production builds!

Actual Results

debug_assertions are enabled leading to major performance degradation.

Version

At least Percona 16.11, 17.7 and 18.1 are affected.

Steps to reproduce

Install percona postgres distribution (i.e. docker images) and see that debug_assertions are "on".

Relevant logs

Code of Conduct

• I agree to follow Percona Community Code of Conduct

[shahidullah79]

This has been fixed, and updated Percona distributed 16.11 Docker images are now available.