> -----Original Message-----
> From: owner-pgsql-hackers(at)postgresql(dot)org
> [mailto:owner-pgsql-hackers(at)postgresql(dot)org]On Behalf Of Tom Lane
>
> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > Just my 0.02c, but I don't like putting limits on an optimizer.
>
> That's my feeling too. I'm leaning towards letting the optimizer do the
> best it can with the given query (which means using OFFSET+LIMIT as the
> estimated number of tuples to be fetched),
What about cursors ?
I heard from Jan that we could specify 'LIMIT ALL' to tell optimizer that
the response to get first rows is needed.
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp