New answers tagged


The way that LIMIT works is tied to how the executor works in general. The PostgreSQL executor calculates each result row from a node in the plan tree as it is needed. So for the plan above, PostgreSQL first tries to calculate the first result from the Limit node. For that, it has to get the first result from the Gather node. That is a node that just ...

Top 50 recent answers are included