4 ms·
Be wary of WITH statements as they are optimization barriers as some engines can't optimize them -- that's changing but just FYI. I believe the latest Postgres
by gigatexal 7y ago
Be wary of WITH statements as they are optimization barriers as some engines can't optimize them -- that's changing but just FYI. I believe the latest Postgres release is handling them properly now -- I could be wrong.
- alexhutcheson 7y agoGood note. Subqueries are sometimes optimization barriers as well - it depends on query engine. If you care about performance you need to look at the query plan.
- gigatexal 7y ago"If you care about performance you need to look at the query plan." Always I would say, once your data gets above toy size.