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
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 |