Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c) - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)
Date
Msg-id 24620.972608356@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Responses Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-committers
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Yes I want to give optimizer a hint  "return first rows fast".
> When Jan implemented LIMIT first,there was an option
> "LIMIT ALL" and it was exactly designed for the purpose.

Well, we could make that work that way again, I think.  Need to look
at the code, but I think the optimizer could tell the difference between
a LIMIT ALL clause and no limit clause at all.

            regards, tom lane

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql (configure)
Next
From: Philip Warner
Date:
Subject: Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)