$lookup join strategies: understanding the trade-offs with flexible documents

In a previous post, I explored how MongoDB chooses between nested loop, indexed loop, and hash join strategies for $lookup . Here, I examine what occurs when $lookup runs on DocumentDB for PostgreSQL—...