search

staudenmeir / laravel-cte

Laravel queries with common table expressions
MIT License
535 stars 40 forks source link

Materialized cte #17

Closed luciuz closed 3 years ago

luciuz commented 4 years ago

Hello!

How to set 'materialized' option to an expression (cte)? Ty

staudenmeir commented 4 years ago

This is not possible at the moment, but I'll look into it.

tpetry commented 3 years ago

@staudenmeir Materialized CTE support for PostgreSQL is really critical as PostgreSQL does not support any optimization hints, materialized ctes are the only option to fix a bad execution plan of postgresql.

staudenmeir commented 3 years ago

I'll try to release this option in the next few weeks.

staudenmeir commented 3 years ago

I released a new version with materialized expressions https://github.com/staudenmeir/laravel-cte#materialized-expressions