scliu的博客

greenplum6上delete命令误删数据可以通过pageinspect插件找回。安装pageinspect插件：create extension pageinspect;安装完成后通过下面的方式找回数据t_data是16进制的数据，需要转换成可读的数据。greenplum6自带的pageinspect没有t_data列，改了代码可以输出t_data。...

停了docker 重启服务器 nf_conntrack 就消失了systemctl stop dockersystemctl disable dockerlsmod | grep conntrack

greenplum 4.3.33 版本遇到生成执行计划需要7秒左右的时间，相关信息如下：Thread 2 (Thread 0x7f64eac77700 (LWP 31116)):#0 0x00007f64e65acdfd in poll () from /lib64/libc.so.6#1 0x0000000000bbb034 in rxThreadFunc (arg=) at ic_udpifc.c:6313#2 0x00007f64e70acdc5 in start_thread () f

testdb=# select oid,pg_relation_filenode(oid),relname from pg_class where relname like 'pg_type%';oid | pg_relation_filenode | relname------+----------------------+----------------------...

gp_resqueue_priority_cpucores_per_segment=16gp_external_enable_exec=ongp_segment_connect_timeout=30minshared_buffers=256MBgp_external_grant_privileges=onmax_fsm_pages=400000max_fsm_relatio...