postgres_vectorization_test icon indicating copy to clipboard operation
postgres_vectorization_test copied to clipboard

Should functions work with vectorization

Open kakoni opened this issue 11 years ago • 1 comments

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

kakoni avatar Oct 08 '14 08:10 kakoni

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

ozgune avatar Oct 09 '14 01:10 ozgune