Andrew Schetinin <aschetinin(at)gmail(dot)com> writes:
> In my specific case, what I've seen from the query execution plans, is that
> without LIMIT the query uses Hash Joins, but once I add LIMIT, it starts
> using Nested Loop Joins almost everywhere.
Usually, that's an appropriate change for a small LIMIT. It's certainly
not a priori evidence of a planner bug.
If you want useful comments about this, please review
about how to provide an adequate description of your problem.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: firstname.lastname@example.org||Date: 2012-02-01 21:49:54|
|Subject: Re: BUG #6421: Revoke column level privilage|
|Previous:||From: Tom Lane||Date: 2012-02-01 21:43:34|
|Subject: Re: BUG #6425: Bus error in slot_deform_tuple |