Re: [pgsql-pkg-debian] pgsql 9.3 for debian/sid in pgdg repo hasasserts enabled causing big performance issues

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [pgsql-pkg-debian] pgsql 9.3 for debian/sid in pgdg repo hasasserts enabled causing big performance issues
Дата
Msg-id 20170610233330.4vadtntqorscxgtv@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [pgsql-pkg-debian] pgsql 9.3 for debian/sid in pgdg repo hasasserts enabled causing big performance issues  (Christoph Berg <myon@debian.org>)
Список pgsql-pkg-debian
On 2017-06-10 22:21:02 +0200, Christoph Berg wrote:
> 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
fromca. 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.

FWIW, I think that's a seriously bad default.  We want people to be able
to do performance tests on sid too, and that's just about impossible
with cassert enabled builds.  Besides that, there's plenty people using
sid as their daily driver, while still actually using postgres in some
way.

- Andres


В списке pgsql-pkg-debian по дате отправления:

Предыдущее
От: Stefan Huehner
Дата:
Сообщение: Re: [pgsql-pkg-debian] pgsql 9.3 for debian/sid in pgdg repo hasasserts enabled causing big performance issues
Следующее
От: Ryan Taylor
Дата:
Сообщение: [pgsql-pkg-debian] Missing Postgis.control