Digoal.zhou
Digoal.zhou
原来使用rsync来修复,耗时太长,而且对IO有比较大的影响。 增加使用pg_rewind修复的功能 作为变量可配置,使用pg_rewind还是rsync
1. 使用相对时间,原来用的是绝对时间 2. 增加主备XLOG延迟的判断,使用相对的XLOG位置 相对位置和相对时间都记录在切换脚本的变量中。
HI, lsm3 index more larger than btree index: ``` postgres=# create index idx on t using lsm3(id) with (unique=true); postgres=# insert into t select generate_series(1,10000000), md5(random()::text); postgres=# \dt+ t List...
HI, when i drop the lsm3 index and reindex it, will generate error like below: ``` postgres=# drop index idx; DROP INDEX postgres=# create index idx on t using lsm3(id)...
HI, now one session will only mapping to one backend process, so when one of the sessoiin attach to the backend process is in idle in transaction mode, so other...
HI, when i use more connection to pool size. and use one session to execute discard all, then all session which mapping to the same backend process with this session's...
HI, there is some testing for zedstore, when i use concurrent insert into on conflict test, here is some buffer_content locks and qps=0; ``` postgres=# do language plpgsql $$ declare...
fix error: ``` fatal: ambiguous argument 'HEAD~1': unknown revision or path not in the working tree. Use '--' to separate paths from revisions, like this: 'git [...] -- [...]' ```
``` cd /tmp git clone --depth 1 -b apache-arrow-12.0.0 https://github.com/apache/arrow.git cd /tmp/arrow/cpp mkdir build-release cd /tmp/arrow/cpp/build-release cmake -DARROW_DEPENDENCY_SOURCE=BUNDLED .. make -j4 make install cd /tmp apt-get install -y libcurl4-openssl-dev uuid-dev...