PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15953
PG Version11.5
OSDebian Sid x64
Opened2019-08-13 13:11:14+00
Reported byrichard

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15953
Logged by:          richard
Email address:      (redacted)
PostgreSQL version: 11.5
Operating system:   Debian Sid x64


i upgraded my server from 11.4-1 ( note, this was the debian package before
) to 11.5-1.pgdg+1 which uses the postgresql apt repository package. after
this upgrade, i noticed a lot more system load and all 4 cores of my server
hit 100% usage by the database.

visualized you can see it here: 
CPU usage

at ~11:10 i installed the new version, afterwards you see the cpu hit 100%
usage and than followed some desperate measures to get the database to
perform normal again, mostly reindex and vacuum full on the given database.
at 14:30 i wondered and installed the debian provided 11.5-1 package and
everything went back to 'normal' without any other changes. there was not a
single cause like a long running query. just everything went a lot slower
and used more cpu. there were no obvious differences in query planning.

the two versions were the following:

# apt-cache policy postgresql-11
  Installed: 11.5-1
  Candidate: 11.5-1.pgdg+1
  Version table:
     11.5-1.pgdg+1 500
        500 sid-pgdg/main amd64
 *** 11.5-1 500
        500 sid/main amd64 Packages
        100 /var/lib/dpkg/status

using pg_config --configure i found only one difference in the build
options, which is --enable-cassert on the postgresql provided version.

whast the deal?


2019-08-13 13:11:14+00PG Bug reporting formBUG #15953: performance issues using 11.5-1.pgdg+1 over 11.5-1
2019-08-14 03:23:53+00easteregg(at)verfriemelt(dot)orgRE: BUG #15953: performance issues using 11.5-1.pgdg+1 over 11.5-1