postgres_vectorization_test
postgres_vectorization_test copied to clipboard
Should functions work with vectorization
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
Hey @kakoni,
Thanks for reporting this. The vectorized executor in its current form only supports aggregate functions and aggregate functions with simple group bys. For this query, we should have either handed the query to the Postgres executor or errored out here.
I'm updating the Limitations section in the Readme to note this limitation. @canguler, if you're reading this comment, we'd love for you to come and work with us in taking this further. :)
Best, Ozgun