Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)
Date: 2000-10-27 00:59:16
Message-ID: 24620.972608356@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2000-10-27 01:53:39 pgsql/src/backend/utils/adt (network.c)
Previous Message Hiroshi Inoue 2000-10-27 00:47:32 Re: pgsql/src/backend/nodes (copyfuncs.c outfuncs.c print.c)

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin O'Gorman 2000-10-27 01:05:05 Select syntax (broken in current CVS tree)
Previous Message Tom Lane 2000-10-27 00:49:22 Re: Re: [GENERAL] A rare error