pgsql 9.3 for debian/sid in pgdg repo has asserts enabled causing big performance issues

From: Stefan Huehner <stefan(at)huehner(dot)org>
To: pgsql-pkg-debian(at)postgresql(dot)org
Cc: stefan(dot)huehner(at)openbravo(dot)com
Subject: pgsql 9.3 for debian/sid in pgdg repo has asserts enabled causing big performance issues
Date: 2017-06-10 13:27:47
Message-ID: 20170610132747.GD11504@huehner.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian

Hello,
please CC me on replies as i am not subscribed to the mailing list.

In short:
The following part from latest changelog:
* debian/rules: Add stub to enable cassert builds (disabled by default).

does not work in practice as in debian/rules file the

#CASSERT_FLAGS := --enable-cassert

line is not commented out as it should have been.

That causes severe peformance issues at least in our use-case of batch-inserting lots of data with runtime going from ca. 1min to >=6min.

Checking with perf shows lots of cpu-cycles spent in AllocSetCheck.

Doing local rebuilt of the source package with the assert disabled fixes the performance issue for me.

apt-cache policy postgresql-9.3
postgresql-9.3:
Installed: 9.3.17-1.pgdg+1
Candidate: 9.3.17-1.pgdg+1
Version table:
9.3.17-1.pgdg+1 500
500 https://apt.postgresql.org/pub/repos/apt sid-pgdg/main amd64 Packages

Apart from 9.3 version as mentioned above it seems to affect more versions.

I did not check manually but checked pg_config output from postgresql-server-dev packages searching for 'assert' and got the following:

for i in `ls /usr/lib/postgresql/`; do echo "Version: $i"; /usr/lib/postgresql/$i/bin/pg_config | grep -c assert; done
Version: 10
0
Version: 8.4
0
Version: 9.0
0
Version: 9.1
0
Version: 9.2
1
Version: 9.3
1
Version: 9.4
1
Version: 9.5
1
Version: 9.6
0

So apparently 9.2..9.5 version has that problem as well.

Regards,
Stefan

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2017-06-10 20:21:02 Re: pgsql 9.3 for debian/sid in pgdg repo has asserts enabled causing big performance issues
Previous Message apt.postgresql.org repository 2017-06-07 10:12:28 repmgr updated to version 3.3.2-1.pgdg+1