From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Walker <failaway(at)qq(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: unrecognized configuration parameter "plpgsql.check_asserts" |
Date: | 2021-03-12 11:11:03 |
Message-ID: | CAFj8pRCykkzURdTQOZ8xxWyK369C8+eOQHq1GJdUGY_pF8K3uQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
pá 12. 3. 2021 v 11:54 odesílatel Walker <failaway(at)qq(dot)com> napsal:
> Hi, hackers
>
> Due to configure with parameter --enable-cassert, the debug_assertions is
> on by default, as follows:
> postgres=# show debug_assertions;
> debug_assertions
> -------------------
> on
>
> Because of pgbench performance testing, I need to disable the assert
> function. Following the doc below, I tried to set plpgsql.check_asserts to
> off to disable assert function.
> https://www.postgresql.org/docs/13/plpgsql-errors-and-messages.html
>
> However, it prompts the following error, not sure if I missed something,
> any thoughts about it?
> postgres=# alter system set plpgsql.check_asserts = off;
> EORROR: unrecognized configuration parameter "plpgsql.check_asserts"
>
you cannot disable debug_assertions. It is possible just by configure, and
make
plpgsql.check_asserts controls evaluation of plpgsql statement ASSERT
Pavel
> env:
> PG: 13.2
> OS: redhat 7.4 3.10.0-693.17.1.e17.x86_64
> configure parameter: --enable-coverage --enable-tap-tests --enable-cassert
> --enable-debug --enable-nls --with-perl --with-python --with-tcl
> --with-openssl --with-ldap --with-libxml --with-libxslt --with-uuid=e2fs
> --with-segsize=10 --with-wal-blocksize=16 --with-llvm LLVM_CONFIG=xxx
> CLANG=xxx
>
>
> thanks
> walker
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2021-03-12 11:34:46 | Re: [Patch] Optimize dropping of relation buffers using dlist |
Previous Message | gkokolatos | 2021-03-12 10:59:19 | Re: Allow batched insert during cross-partition updates |