Murat Tuncer

we are moving towards using internal storage where this is no longer an issue

Citus extension has recently started supporting columnar tables please see https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-postgres It uses PostgreSQL's recent table access method features and have better performance than the architecture cstore_fdw was build on....

This behavior comes from postgres. I don't think we should try to fix this within cstore_fdw

If you are building PostgreSQL from sources you can add it to CFLAGS when doing ./configure

Hi @matteodurighetto Could you provide the steps leading to this crash ? That would help reproducing the issue at our end. thanks

@matteodurighetto still I can't reproduce. Tried at Centos 7.1 at AWS with Postgresql 9.5.3 installed from yum.postgresql.org and cstore_fdw v1.4.1 downloaded from github. I also tried with pgbench to concurrently...

hi @domoritz Yes it would be nice. In fact there was an [attempt](https://github.com/Homebrew/homebrew-head-only/pull/46/files) by @nathansgreen that did not go through some time back. I am leaving this issue open for...

Could you run analyze on the table to see if it makes any difference ? We have seen a substantial difference when a query involved joins or subqueries in similar...

I don't know of anybody using cstore_fdw under windows. The main challenge would be to get depended library `protobuf-c` to compile under windows. I have heard of people doing that...

You having to create cstore_fdw folder tells something is not right with file system access. can you run this under debugger to see where it fails (crashes) ?