JackGao

Postgresql column storage has a great impact on performance, optimize column storage to PLAIN or EXTERNAL.

https://github.com/digoal/pgsql_admin_script/blob/5fbdcc8c71507c622dff4bc0976456b73e60a53b/generate_report.sh#L781-L799 这里用到的3个SQL在PG10中有改动 ```sql -- PG9 select pg_xlogfile_name(pg_current_xlog_location()) now_xlog, * from pg_stat_archiver; -- PG10 select pg_walfile_name(pg_current_wal_lsn()) now_xlog, * from pg_stat_archiver; ``` ```sql --PG9 select pg_xlog_location_diff(pg_current_xlog_location(),flush_location), * from pg_stat_replication --PG10 select pg_wal_lsn_diff(pg_current_wal_lsn(),flush_lsn),...

``` SVMClassification.cc: In function ‘SVMProblem* GetSVMProblemWithPreKernel2(Trial*, Voxel*, int, int, int)’: SVMClassification.cc:230:73: error: ‘kmp_malloc’ was not declared in this scope prob->x[i] = (SVMNode*)kmp_malloc(sizeof(SVMNode) * (nTrainings + 2)); ^ SVMClassification.cc: At global...