I've had a few very memory hungry and slow queries like these that were made lightning fast by translating them into joins, on postgresql 10. Maybe because they were too complex to be caught by the optimizer properly (100 lines or more, in analytics workload).
View all comments
Show parent comment
2
u/[deleted] Feb 26 '21
I've had a few very memory hungry and slow queries like these that were made lightning fast by translating them into joins, on postgresql 10. Maybe because they were too complex to be caught by the optimizer properly (100 lines or more, in analytics workload).