imcs
imcs copied to clipboard
knizhnik
In-Memory Columnar Store extension for PostgreSQL
Hi, We have been using a long time now table level locking branch. In our application we have multiple databases on one postgres instance and they all use IMCS heavily....
CentOS7.1 PG10.3 ./install.sh error: func.c: In function ‘imcs_cast_to_char_next’: func.c:1066:16: error: ‘FLT_DIG’ undeclared (first use in this function) ndig = FLT_DIG + extra_float_digits; ^ func.c:1066:16: note: each undeclared identifier is reported...
Hi, When having many columns like in this example there is an error: ERROR: cache lookup failed for function 4 *********\* Error ********** ERROR: cache lookup failed for function 4...
hi,knizhnik: i install imcs exetension in my postgres 9.3.5, i modify install.sh to: PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 USE_DISK=1 CFLAGS="-g3 --save-temps -Wall -Wno-format-security -DIMCS_DISK_SUPPORT " LDFLAGS="-pthread" install. and my postgres.conf is :...
this may be the reason of #34 when load data use table_load(),some columns of cs has less data than the ori table. this is the reproduce step: crash=> select crashlog_truncate();...
for same data,if filter is countryid =1 ,the sql report error: ERROR: group by sequence doesn't match values sequence while if the filter is countryid =2 or countryid =3 ,then...
I try to run the test file in imcs/sql/ dir on FreeBSD,find some tests hang as flowing: psql postgres -f sql/create.sql OK [~/postgresql/contrib/imcs/sql]$ psql postgres -f ./sql/grandagg.sql ## quote_count ```...
cc -g -Wall -fPIC -DPIC -I. -I. -I/usr/home/jovz/pgsql934/include/server -I/usr/home/jovz/pgsql934/include/internal -c -o imcs.o imcs.c imcs.c:693:51: warning: format string is not a string literal (potentially insecure) [-Wformat-security] ereport(ERROR, (errcode(err_code), errmsg(err_buf))); ^~~~~~~ /usr/home/jovz/pgsql934/include/server/utils/elog.h:133:37:...
I can use cs = cs to get a boolean cs: crash=> select cs_filter(cs_const(1)=cs_const(1),uin) from crashlog_get(604176597); NOTICE: IMCS command: const CONTEXT: PL/pgSQL function cs_const(double precision,cs_elem_type) line 1 at RETURN NOTICE:...
I see RLE in imcs,it is greate,but I think the benefit is limited for real world compare with common compression algorithm such as lz4,lzo,snappy. infobright can reach 10:1~40:1 compression ratio,may...