pg_toast.pg_toast_relfilenode not exist due to vacuum full tablename

2022-09-10 Thread walker
_binary_file('filename')); \d+ pg_toast.pg_toast_relfilenode  --- it's ok, the toast table exists vacuum full reymont; \d+ pg_toast.pg_toast_relfilenode  --- it's ok, the toast table exists it looks a little strange, any ideas? appreciate your help. env: pg14.4 linux 3.10.0-693.17.1.e17 thanks walker

Re: ?????? unrecognized configuration parameter "plpgsql.check_asserts"

2021-03-12 Thread Walker
thanks Julien & Pavel it's crystal clear now. thanks again for your kindly help  thanks walker -- Original -- From: "Julien Rouhaud"

?????? unrecognized configuration parameter "plpgsql.check_asserts"

2021-03-12 Thread Walker
hanks walker --  -- ??: "Pavel Stehule"

unrecognized configuration parameter "plpgsql.check_asserts"

2021-03-12 Thread Walker
dap --with-libxml --with-libxslt --with-uuid=e2fs --with-segsize=10 --with-wal-blocksize=16 --with-llvm LLVM_CONFIG=xxx CLANG=xxx thanks walker

Re: make coverage-html would fail within build directory separate from source tree

2021-03-04 Thread walker
4 lcov_base.info lcov_test.info touch coverage-html-stamp thanks walker -- Original -- From: "Tom Lane"

Re: make coverage-html would fail within build directory separate from source tree

2021-03-04 Thread walker
install a newer version of lcov 1.13, it works fine with WARNING just same as yours. much appreciated thanks walker -- Original -- From

011_crash_recovery.pl failes using wal_block_size=16K

2021-03-04 Thread walker
t get flushed into wal file on disk. Instead, if delay some time, e.g. 200ms, or more after issue create table, in theory, the data in wal buffer should be written to disk by wal writer. However, I'm not sure the root cause. what's the difference between wal_blocksize=8k and wal_blocksize=16k while flushing wal buffer data to disk? thanks walker

Re: make coverage-html would fail within build directory separate from source tree

2021-03-04 Thread walker
The same, the build directory is outside the source tree. the version of lcov is 1.10 thanks walker -- Original -- From: "Alvaro Herrera"

Re: make coverage-html would fail within build directory separate from source tree

2021-03-04 Thread walker
e-coverage make make check make coverage-html thanks walker -- Original -- From: "Alvaro Herrera"

make coverage-html would fail within build directory separate from source tree

2021-03-04 Thread walker
: *** Deleting file 'lcov_base.info' if I repeat the above steps within the source tree directory, make coverage-html works fine. From the official documentation, I didn't find any limitations for "make coverage-html", not sure if I miss something. thanks walker  

psql crash while executing core regression tests

2021-03-02 Thread walker
check testing environment: PostgreSQL: 13.2 redhat 7.4, 3.10.0-693.e17.x86_64 flex: 2.5.37 thanks walker