Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

It's not as easy as it could be but you can accomplish aggregate pushdown by using executor hooks in your FDW. As an example I'd point you to our (Citus Data) recent work on doing this with our columnar store foreign data wrapper:

https://github.com/citusdata/postgres_vectorization_test

As discussed there it definitely showed promise in improving performance for us.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: