Tom Lane wrote:
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Tom Lane wrote:
> >> Now that I look at it, the optimizer *already* prefers fast-start plans
> >> for cursors. Is LIMIT ALL really necessary as an additional hint,
> >> and if so how should it interact with the bias for cursors?
>
> > If LIMIT doesn't restrict the total count of rows which cursors
> > could return,there's no problem. Otherwise LIMIT ALL would be
> > needed.
>
> But is there a reason to treat LIMIT ALL differently from no LIMIT
> clause at all?
>
For example,LIMIT ALL means LIMIT 1 for optimizer and means
no LIMIT for executor.
Comments ?
Regards, Hiroshi Inoue.