search

apache / datasketches-postgresql

PostgreSQL extension providing approximate algorithms based on apache/datasketches-cpp
https://datasketches.apache.org
Apache License 2.0
85 stars 11 forks source link

Make aggregations parallel SAFE #61

Closed andyndang closed 1 year ago

andyndang commented 1 year ago

In order for postgres to execute parallel execution plan, the aggregation function needs to be marked as SAFE.

Reading this documentation it requires the function to specify a combiner: https://www.postgresql.org/docs/current/sql-createaggregate.html#:~:text=An%20aggregate%20can%20optionally%20support%20partial,PARALLEL%20SAFE%20to%20enable%20parallel%20aggregation.

Would be nice if this extension can support that!

AlexanderSaydakov commented 1 year ago

I will look into this.

AlexanderSaydakov commented 1 year ago

fixed by #63

AlexanderSaydakov commented 1 year ago

@andyndang The change is in the master. Would you be willing to try this before the next release?

AlexanderSaydakov commented 1 year ago

@andyndang 1.6.0-rc1 release candidate is out there. The vote is open. You are welcome to participate.

AlexanderSaydakov commented 1 year ago

1.6.0 has been released

jmalkin commented 1 year ago

Full release notes are available here: https://github.com/apache/datasketches-postgresql/releases/tag/1.6.0