citusdata / postgres_vectorization_test Goto Github PK

Hi,

SELECT count(*) from cstore_table;
SELECT sum(int_value) from cstore_table;
SELECT avg(bigint_value) from cstore_table;

For all the above mentioned queries , psql is killed and i get the following error

"The connection to the server was lost. Attempting reset: Failed"

Thanks,
Harsha

I've got pretty simple table;

CREATE FOREIGN TABLE samples_cstore
(
  id             integer,
  sampled_at     timestamp without time zone
)

Trying run datetrunc with grouping as

select date_trunc('day', sampled_at) from samples_cstore group by 1;

kills psql, I get

The connection to the server was lost. Attempting reset: Failed.

I'm on osx 10.9 with homebrewed postgres 9.3