On Tue, Jan 20, 2009 at 10:45 AM, Yannick Le Guédart
wrote:
>
> The second query scans the whole comment table which is very dangerous for
> production servers.
That's not quite true. The second does an index scan- the planner
seems to be guessing that it'll fulfill the required limit early in
t
Greetings,
I'm experiencing a strange query plan change on a "simple" request, based on
the LIMIT parameter. I present here two tables, named _article and _comment.
they are part of a much larger database.
It's a tree-like database (making use of the ltree to keep the coherence),
and in our case,
