Re:Working around a case where the Postgres planner is “not ...
by barrkel on Monday August 02, 2021 @08:12PM
(#28044330)
Window functions can help here. You can try a self-join with MySQL (and it won't do a hash join because it doesn't have it; it didn't have hash joins at all before 8.10 and it still doesn't have hash outer joins, and what you want to eliminate the older rows is an anti-join, i.e. asserting null on a left join) but honestly you're better off sorting by timestamp and using a manual window when processing the results.
[ Parent
| on HN ]
There are no comments on this comment yet.