From: Christoph Berg <myon@debian.org>
To: Stefan Huehner <stefan@huehner.org>
Cc: pgsql-pkg-debian@postgresql.org
Cc: stefan.huehner@openbravo.com
Subject: Re: pgsql 9.3 for debian/sid in pgdg repo has asserts enabled causing big performance issues
Date: Sat, 10 Jun 2017 22:21:02 +0200
Message-ID: <20170610202102.vz5l4eudghktvwgj@msg.df7cb.de> (raw)
In-Reply-To: <20170610132747.GD11504@huehner.biz>
References: <20170610132747.GD11504@huehner.biz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-pkg-debian>
Re: Stefan Huehner 2017-06-10 <20170610132747.GD11504@huehner.biz>
> 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.
Hi,
I'm sorry for not properly announcing and documenting this recent
change properly, we should put a note on the wiki page.
What's happening is that in git the line is indeed commented out, but
then the apt.postgresql.org build scripts will activate the line when
building for sid-pgdg (which is the whole point why that stub logic
got introduced). The idea is that one of the distributions on
apt.postgresql.org should have cassert enabled so the testsuites
exercise more test cases, for the server packages as well as for
extension packages. As sid is Debian's development branch, it made
sense to enable cassert there.
You seem to use the sid-pgdg packages for production data - is there a
reason you are not using jessie-pgdg or stretch-pgdg?
Christoph
--
Sent via pgsql-pkg-debian mailing list (pgsql-pkg-debian@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-debian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-pkg-debian@postgresql.org
Cc: myon@debian.org, stefan@huehner.org, stefan.huehner@openbravo.com
Subject: Re: pgsql 9.3 for debian/sid in pgdg repo has asserts enabled causing big performance issues
In-Reply-To: <20170610202102.vz5l4eudghktvwgj@msg.df7cb.de>
References: <20170610132747.GD11504@huehner.biz> <20170610202102.vz5l4eudghktvwgj@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox