On Sun, Jul 11, 2021, at 4:39 PM, Euler Taveira wrote: > with cache (v18) > ----------------------- > > mean: 0.63 us > stddev: 1.07 us > median: 0.55 us > min-max: [0.29 .. 844.87] us > percentile(99): 1.38 us > mode: 0.41 us > > It represents -57%. It is a really good optimization for just a few extra > lines > of code. cfbot seems to be unhappy with v18 on some of the hosts. Cirrus/FreeBSD failed in the test 010_truncate. It also failed in a Cirrus/Linux box. I failed to reproduce in my local FreeBSD box. Since it passes appveyor and Cirrus/macos, it could probably be a transient issue.
$ uname -a FreeBSD freebsd12 12.2-RELEASE FreeBSD 12.2-RELEASE r366954 GENERIC amd64 $ PROVE_TESTS="t/010_truncate.pl" gmake check gmake -C ../../../src/backend generated-headers gmake[1]: Entering directory '/usr/home/euler/pglr-row-filter-v17/src/backend' gmake -C catalog distprep generated-header-symlinks gmake[2]: Entering directory '/usr/home/euler/pglr-row-filter-v17/src/backend/catalog' gmake[2]: Nothing to be done for 'distprep'. gmake[2]: Nothing to be done for 'generated-header-symlinks'. gmake[2]: Leaving directory '/usr/home/euler/pglr-row-filter-v17/src/backend/catalog' gmake -C utils distprep generated-header-symlinks gmake[2]: Entering directory '/usr/home/euler/pglr-row-filter-v17/src/backend/utils' gmake[2]: Nothing to be done for 'distprep'. gmake[2]: Nothing to be done for 'generated-header-symlinks'. gmake[2]: Leaving directory '/usr/home/euler/pglr-row-filter-v17/src/backend/utils' gmake[1]: Leaving directory '/usr/home/euler/pglr-row-filter-v17/src/backend' rm -rf '/home/euler/pglr-row-filter-v17'/tmp_install /bin/sh ../../../config/install-sh -c -d '/home/euler/pglr-row-filter-v17'/tmp_install/log gmake -C '../../..' DESTDIR='/home/euler/pglr-row-filter-v17'/tmp_install install >'/home/euler/pglr-row-filter-v17'/tmp_install/log/install.log 2>&1 gmake -j1 checkprep >>'/home/euler/pglr-row-filter-v17'/tmp_install/log/install.log 2>&1 rm -rf '/usr/home/euler/pglr-row-filter-v17/src/test/subscription'/tmp_check /bin/sh ../../../config/install-sh -c -d '/usr/home/euler/pglr-row-filter-v17/src/test/subscription'/tmp_check cd . && TESTDIR='/usr/home/euler/pglr-row-filter-v17/src/test/subscription' PATH="/home/euler/pglr-row-filter-v17/tmp_install/home/euler/pgrf18/bin:$PATH" LD_LIBRARY_PATH="/home/euler/pglr-row-filter-v17/tmp_install/home/euler/pgrf18/lib" LD_LIBRARY_PATH_RPATH=1 PGPORT='69999' PG_REGRESS='/usr/home/euler/pglr-row-filter-v17/src/test/subscription/../../../src/test/regress/pg_regress' /usr/local/bin/prove -I ../../../src/test/perl/ -I . t/010_truncate.pl t/010_truncate.pl .. ok All tests successful. Files=1, Tests=14, 5 wallclock secs ( 0.02 usr 0.00 sys + 1.09 cusr 0.99 csys = 2.10 CPU) Result: PASS -- Euler Taveira EDB https://www.enterprisedb.com/
